Has anyone picked up on this yet?
Mar 30, 2023
3
Level 1
Support PostrgeSQL's new "UNIQUE NULLS NOT DISTINCT" constraint
With PostgreSQL 15, a tweaked version of the UNIQUE constraint was released that treats NULL values as duplicates across rows.
I couldn't find anything in the source or docs that suggest this already being available.
Sources:
https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-UNIQUE-CONSTRAINTS
https://www.postgresql.org/docs/15/release-15.html#id-1.11.6.7.5.3.4
Please or to participate in this conversation.