pgsql: Doc: clarify NULLS NOT DISTINCT use in unique indexes

From: David Rowley <drowley(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: clarify NULLS NOT DISTINCT use in unique indexes
Date: 2023-04-20 11:53:03
Message-ID: E1ppSqU-003zRY-8t@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: clarify NULLS NOT DISTINCT use in unique indexes

indexes-unique.html mentioned nothing about the availability of NULLS NOT
DISTINCT to modify the NULLs-are-not-equal behavior of unique indexes.
Add this to the synopsis and clarify what it does regarding NULLs.

Author: David Gilman, David Rowley
Reviewed-by: Corey Huinker
Discussion: https://postgr.es/m/CALBH9DDr3NLqzWop1z5uZE-M5G_GYUuAeHFHQeyzFbNd8W0d=Q@mail.gmail.com
Backpatch-through: 15, where NULLS NOT DISTINCT was added

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/94d73f9abdf13e6dd93d96d0e4b197479c8756de

Modified Files
--------------
doc/src/sgml/indices.sgml | 10 ++++++----
1 file changed, 6 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2023-04-20 13:28:29 Re: pgsql: Fix list_copy_head() with empty Lists
Previous Message David Rowley 2023-04-20 11:52:22 pgsql: Doc: clarify NULLS NOT DISTINCT use in unique indexes