News for hackers. Stuff that matters.
Re:SQL NULLs Are Weird by marcosdumay on Friday January 10, 2025 @09:50AM (#42656034)
Yes, ergonomics dictates some weird behavior for nulls.

Luckily, Postgres nowadays lets you declare the behavior of each null in unique constraints, like it should be. We can expect this to creep down to the other DBMSs with time.

Making nulls distinct on a "select distinct" or a "group by" would be completely useless.

Re:SQL NULLs Are Weird by Pxtl on Friday January 10, 2025 @10:17AM (#42656322)
If you're compromising on your high-minded and unorthodox purist concept for ergonomics, you may as well finish the job of ergonomics and just use normal nulls where X=X is true.