News for hackers. Stuff that matters.
Re:SQL NULLs Are Weird by Aloisius on Thursday January 09, 2025 @09:43PM (#42651953)
MS SQL Server treats NULLs as indistinct for UNIQUE constraints, SELECT DISTINCT and for UNION.

Indeed, the sqlite page the pull quote is from says as much.

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.