Hacker News new | ask | show | jobs
by Pxtl 3879 days ago
That would be sensible if SQL dialects usually offered a sane comparison that returns true/false reasonably for null comparisons. Since they don't, and = is the only available equality test, I'm going to stick to my original point that null comparison in SQL is dumb and wrong for 99% of use-cases and compiler warnings would be solving the wrong problem.
1 comments

MySql, Postgres, and Vertica, at least, all support <=> as an operator that treats NULL as an ordinary, distinct value.