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 radiospiel on Monday July 11, 2022 @05:43PM (#32062330)
You might want to look at a unique partial index: "CREATE UNIQUE INDEX foo ON pages(name, parent_id) WHERE parent_id IS NOT NULL"
[ Parent | on HN ]

There are no comments on this comment yet.