3 ms·
No. 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/8
by adontz 5y ago
No. 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.