Re:Handling Null Values in Postgres
by Tostino on Friday March 06, 2020 @12:03AM
(#22501119)
...I think you are misunderstanding the whole reason for the IS NOT DISTINCT FROM operator, which is exactly that.
"SELECT NULL = NULL" will return NULL, use that if you want the standard way. There are many cases where you want it to return true though, and the boilerplate for that sucks, so IS NOT DISTINCT FROM has a very useful place in the dialect.
"SELECT NULL = NULL" will return NULL, use that if you want the standard way. There are many cases where you want it to return true though, and the boilerplate for that sucks, so IS NOT DISTINCT FROM has a very useful place in the dialect.