Y
Hacker News
new
|
ask
|
show
|
jobs
by
hans_castorp
521 days ago
> MS SQL Server treats NULLs as indistinct for UNIQUE constraints
Postgres lets you control that behaviour when creating the constraint (or index)
1 comments
swiftcoder
521 days ago
Although only in relatively recent versions. I had to hack around this in TypeOrm, because their Postgres backend hasn't exposed the option yet.
link