Nulls Not Distinct in Unique Indexes secton

Поиск
Список
Период
Сортировка
От Kirk Parker
Тема Nulls Not Distinct in Unique Indexes secton
Дата
Msg-id CANwZ8r=hCu6=w=JRER27t9DMwvVngD55DmkU+NX_AZSfkm1KNg@mail.gmail.com
обсуждение исходный текст
Ответ на The use "Postgres" in docs  (Daniel Gustafsson <daniel@yesql.se>)
Ответы Re: Nulls Not Distinct in Unique Indexes secton  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-docs
The Unique Indexes section (https://www.postgresql.org/docs/15/indexes-unique.html) does not mention the new NULLS [ NOT ] DISTINCT capability of indexes (https://www.postgresql.org/docs/15/sql-createindex.html), and it probably should.

Specifically, it has the exact wording from previous versions (emphasis added):

    When an index is declared unique, multiple table
    rows with equal indexed values are not allowed.
    *Null values are not considered equal*.

We should consider adding "unless the NULLS NOT DISTINCT clause is used when creating the index", or something to that effect.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: The use "Postgres" in docs
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Nulls Not Distinct in Unique Indexes secton