3 ms·
SQL is one of the very few places where I deem null to be valid (altough, you could normalize all nulls away, most of the time it isn't worth it) The null != n
by Akronymus 2y ago
SQL is one of the very few places where I deem null to be valid (altough, you could normalize all nulls away, most of the time it isn't worth it)
The null != null thing is something I quite like, as it simplifies a lot of joins/queries.
and as jraph said, null in relational databases has a very different meaning than null in most programming languages.
Don't know vs not assigned