agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedCREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ];
2+ messages / 2 participants
[nested] [flat]
* CREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ];
@ 2024-11-10 11:36 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2024-11-10 11:36 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: tim.dadd@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/indexes-unique.html
Description:
This says it works from 12 onwards but actually from 15 onwards
Prior to 15 unique partial indexes needed creating, e.g. (parent_ID, NAME)
where parent_ID is not null and (NAME) where parent_id is null
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ];
@ 2024-11-12 08:45 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2024-11-12 08:45 UTC (permalink / raw)
To: tim.dadd@gmail.com; pgsql-docs@lists.postgresql.org
Hello Tim,
On 2024-Nov-10, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/indexes-unique.html
> Description:
>
> This says it works from 12 onwards but actually from 15 onwards
> Prior to 15 unique partial indexes needed creating, e.g. (parent_ID, NAME)
> where parent_ID is not null and (NAME) where parent_id is null
I don't find any text on that page that says this is supported from 12
onwards (click on the number above and you get a different page). If
you go to the page for version 14, the NULLS NOT DISTINCT bit is not
there. Only in the page for version 15 does that text appear.
Thanks for reporting,
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-11-12 08:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-10 11:36 CREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ]; PG Doc comments form <noreply@postgresql.org>
2024-11-12 08:45 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox