Re: Note new NULLS NOT DISTINCT on unique index tutorial page - Mailing list pgsql-hackers

From David Rowley
Subject Re: Note new NULLS NOT DISTINCT on unique index tutorial page
Date
Msg-id CAApHDvpqo980kCY_x=NvCtGk5wCf3pjCRXeBWKSnUHf1M=Yt-g@mail.gmail.com
Whole thread Raw
In response to Note new NULLS NOT DISTINCT on unique index tutorial page  (David Gilman <davidgilman1@gmail.com>)
Responses Re: Note new NULLS NOT DISTINCT on unique index tutorial page  (David Gilman <davidgilman1@gmail.com>)
List pgsql-hackers
On Thu, 13 Apr 2023 at 02:40, David Gilman <davidgilman1@gmail.com> wrote:
> The SQL Language part of the docs has a brief page on unique indexes.
> It doesn't mention the new NULLS NOT DISTINCT functionality on unique
> indexes and this is a good place to mention it, as it already warns
> the user about the old/default behavior.

I think we should do this and apply it to v15 too.

It seems like a good idea to include the [NULLS [NOT] DISTINCT] in the
syntax synopsis too. Otherwise, the reader of that page is just left
guessing where they'll put NULLS NOT DISTINCT to get the behaviour
you've added the text for.

I've attached an updated patch with that plus 2 very small wording
tweaks to your proposed text.

David

Attachment

pgsql-hackers by date:

Previous
From: sirisha chamarthi
Date:
Subject: Re: Fix documentation for max_wal_size and min_wal_size
Next
From: Peter Geoghegan
Date:
Subject: Do we really need two xl_heap_lock records?