News for hackers. Stuff that matters.

A comment on Postgres 15 improves UNIQUE and NULL. Parent comment

Re:Postgres 15 improves UNIQUE and NULL by anamexis on Monday July 11, 2022 @08:50AM (#32055480)
I can't imagine the standard does not specify that NULLS DISTINCT should treat nulls as distinct and NULLS NOT DISTINCT should treat nulls as not distinct.
[ Parent | on HN ]
Re:Postgres 15 improves UNIQUE and NULL by rst on Monday July 11, 2022 @11:48AM (#32057713)
Ah. So there are three ways to write it, and explicit ways to call for either behavior. That's sane -- just wasn't what I got from the original writeup.
[ Parent | on HN ]