Re: Note new NULLS NOT DISTINCT on unique index tutorial page
David Rowley <dgrowleyml@gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
To: David Gilman <davidgilman1@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-04-18T03:15:19Z
Lists: pgsql-hackers
Attachments
- doc_nulls_not_distinct_v2.patch (application/octet-stream) patch v2
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
Commits
-
Doc: clarify NULLS NOT DISTINCT use in unique indexes
- 94d73f9abdf1 15.3 landed
- 0d0aeb04c127 16.0 landed