Postgres 15 improves UNIQUE and NULL

Re:Postgres 15 improves UNIQUE and NULL by feanaro on Monday July 11, 2022 @11:28AM (#32057411)

So of the three major SQL implementations, you have one of them following the results of the settled debate, one of them being an exception and one of them huffling glue (whatever that means). In addition, there's a language exception even in the settled group, which you have to handwave away.

Sounds pretty unsettled to me.

[ Parent | on HN ]

Re:Postgres 15 improves UNIQUE and NULL by irrational on Monday July 11, 2022 @11:37AM (#32057539)

Oracle considers null to be equal to empty string.

[ Parent | on HN ]

Re:Postgres 15 improves UNIQUE and NULL by mike_hock on Monday July 11, 2022 @03:18PM (#32060489)

That is truly huffing glue.

[ Parent | on HN ]