WingNews logo WingNews
top | item 42648155

(no title)

kurtbuilds | 1 year ago

If you want equality testing with nulls, you want to use `is (not) distinct from` instead of `=` and `<>` / `!=`.

`1 is not distinct from NULL` => false

`NULL is not distinct from NULL` => true

`0 is not distinct from 1` => false

discuss

order

blast|1 year ago

Having that is much better than not having it, but man is it verbose and confusing.