Re: Note new NULLS NOT DISTINCT on unique index tutorial page

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Note new NULLS NOT DISTINCT on unique index tutorial page
Дата
Msg-id CADkLM=dZ8pqbx7wLKKwxTUH31_5uZ9Bc7t0bDQYc3fWY+aJBQw@mail.gmail.com
обсуждение исходный текст
Ответ на Note new NULLS NOT DISTINCT on unique index tutorial page  (David Gilman <davidgilman1@gmail.com>)
Ответы Re: Note new NULLS NOT DISTINCT on unique index tutorial page
Список pgsql-hackers
Дерево обсуждения
On Wed, Apr 12, 2023 at 10:40 AM 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'm ok with the wording as-is, but perhaps we can phrase it as "distinct" vs "not equal", thus leaning into the syntax a bit:

By default, null values in a unique column are considered distinct, allowing multiple nulls in the column.

or maybe

By default, null values in a unique column are considered <literal>DISTINCT</literal>, allowing multiple nulls in the column.

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

Предыдущее
От: Jacob Champion
Дата:
Сообщение: Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert
Следующее
От: Tom Lane
Дата:
Сообщение: Re: v16dev: TRAP: failed Assert("size > SizeOfXLogRecord"), File: "xlog.c", Line: 1055, PID: 13564