3 ms·
Can’t you rewrite the second of those so it becomes the first, hence rewriting `>` into `<`?
by pansa2 5y ago
Can’t you rewrite the second of those so it becomes the first, hence rewriting `>` into `<`?
- adontz 5y agoNo. NULL compared to anything in any way is false. http://sqlfiddle.com/#!4/d8fff5/14/0 http://sqlfiddle.com/#!4/d8fff5/14/0 http://sqlfiddle.com/#!17/9eecb/83597/0 http://sqlfiddle.com/#!17/9eecb/83597/0 http://sqlfiddle.com/#!18/9eecb/142653/0 http://sqlfiddle.com/#!18/9eecb/142653/0
- pansa2 5y agoYou still don’t need `>` for any of those examples though, do you? For example, `NULL > 1` could be rewritten as `1 < NULL` (even though it can’t be rewritten as `not(NULL <= 1)`.
- adontz 5y agoWhat do you mean by rewritten? In func_a() > func_b() I expect left-to-right execution order. Not that it should matter in a good code, but anyway.