Re:Postgres 15 improves UNIQUE and NULL
by zeugmasyllepsis on Monday July 11, 2022 @03:59PM
(#32061005)
Playing around in a docker image of the beta build, it looks like this allows you to add a `unique nulls not distinct` constraint to a composite set of fields, but still does not allow you to specify those same fields a primary key. For example
but
fails with a message like "ERROR: column "optional_filter" of relation "announcement_destinations" contains null values". Is there a motivation for this distinction?
[ Parent
| on HN ]
There are no comments on this comment yet.