On Thu, 13 Apr 2023 at 02:40, David Gilman <davidgilm...@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
doc_nulls_not_distinct_v2.patch
Description: Binary data