News for hackers. Stuff that matters.

A comment on Postgres 15 improves UNIQUE and NULL. Parent comment

Re:Postgres 15 improves UNIQUE and NULL by Justsignedup on Monday July 11, 2022 @01:52PM (#32059369)
Currently nulls are considered not distinct in postgres, no? Doesn't this mean anyone upgrading will have to fix up all their table definitions? Or am I wrong about this?

I just care about the backwards compat. To be clear, the second I saw this I thought "finally!!!"

[ Parent | on HN ]
Re:Postgres 15 improves UNIQUE and NULL by masklinn on Tuesday July 12, 2022 @12:19AM (#32065583)
> Or am I wrong about this?

This one. Currently nulls are always distinct (different from one another).

[ Parent | on HN ]