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.
[ Parent
| on HN ]