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
