Re:SQL NULLs Are Weird
by hans_castorp on Friday January 10, 2025 @03:55AM
(#42653900)
> MS SQL Server treats NULLs as indistinct for UNIQUE constraints
Postgres lets you control that behaviour when creating the constraint (or index)
Re:SQL NULLs Are Weird
by swiftcoder on Friday January 10, 2025 @09:37AM
(#42655893)
Although only in relatively recent versions. I had to hack around this in TypeOrm, because their Postgres backend hasn't exposed the option yet.
Indeed, the sqlite page the pull quote is from says as much.