News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by goto11 on Monday July 11, 2022 @05:20AM (#32053909)
Lets say you have a Person table with with a SSN column. The column has a unique constraint because no two people have the same SSN. But the column in nullable, since not everyone has a SSN.

It would be weird to expect that only one person does not have SSN.

There are no comments on this comment yet.