News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by nicoburns on Monday July 11, 2022 @05:26AM (#32053947)
> The closest thing in most langages is nan and developers also find nan weird.

I'd argue the closest thing in most languages is the null propagation operator (usually using a ? symbol) that at least JavaScript and C# have.

YMMV, but personally the unique index behaviour was the main thing I found weird about NULLs. So now that I can turn that off I'm pretty happy with them.

Re:Postgres 15 improves UNIQUE and NULL by masklinn on Monday July 11, 2022 @05:53AM (#32054117)
> I'd argue the closest thing in most languages is the null propagation operator (usually using a ? symbol) that at least JavaScript and C# have.

In what sense? null-coalescing operators don’t change how nulls behave or relate to one another, they only provide convenience operators for conditioning operation upon them, like sql’s COALESCE.