On 27.08.21 14:44, Marko Tiikkaja wrote:
On Fri, Aug 27, 2021 at 3:38 PM Peter Eisentraut
<peter.eisentr...@enterprisedb.com
<mailto:peter.eisentr...@enterprisedb.com>> wrote:
In the SQL:202x draft, this
has been formalized by making this implementation-defined and adding
an option on unique constraint definitions UNIQUE [ NULLS [NOT]
DISTINCT ] to choose a behavior explicitly.
The CREATE UNIQUE INDEX syntax extension is not from the standard,
it's my own invention.
For the unique index syntax, should this be selectable per
column/expression, rather than for the entire index as a whole?
Semantically, this would be possible, but the bookkeeping to make it
work seems out of proportion with the utility. And you'd have the
unique index syntax out of sync with the unique constraint syntax, which
would be pretty confusing.
