On Sun, 2024-12-15 at 17:35 +0000, Luca Dametto wrote: > Most programming languages return "true" when two null values are compared, > and false when, being the two values nullable, one of them is null and the > other one isn't. > > [not SQL, however] > > Whilst I'd love to discuss the reasons of this, I understand that it would > be a waste of time for everyone, as we cannot change the status-quo even > if it made sense, as it would break many thousands of projects. > > For that reason, I'd just like to improve the documentation to add at least > a note about "hey, this won't work as you might expect, because it works > in a different way than 99% of programming languages out there.". There are already efforts to improve the documentation concerning NULL: https://commitfest.postgresql.org/51/5086/ If that doesn't cover your case, perhaps you can join the discussion and suggest improvements. Yours, Laurenz Albe