News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by zeroimpl on Monday July 11, 2022 @09:51AM (#32056117)
I think this is a great change. I wish NULLS NOT DISTINCT was the default already - if I wanted the constraint to ignore null values I’d have used a partial index to only index non-null values. Doing the opposite is much more difficult.
Re:Postgres 15 improves UNIQUE and NULL by masklinn on Tuesday July 12, 2022 @12:45AM (#32065750)
It will never be the default.