News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by jhugo on Monday July 11, 2022 @06:02AM (#32054179)
Honestly it's what you want way more often than not. A unique index on a nullable column is usually representing some optional identifier. You wouldn't usually want only one row to be able to omit the identifier.
Re:Postgres 15 improves UNIQUE and NULL by vasachi on Monday July 11, 2022 @06:41AM (#32054404)
Oh yeah, totally. But not always. I'm very glad that we now have an option to have both behaviours.