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.
Postgres lets you control that behaviour when creating the constraint (or index)