agora inbox for pgsql-docs@postgresql.org  

help / color / mirror / Atom feed

From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: tim.dadd@gmail.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: CREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ];
Date: Tue, 12 Nov 2024 09:45:12 +0100
Message-ID: <202411120845.iyhet5dzacwy@alvherre.pgsql> (raw)
In-Reply-To: <173123859233.708.15625173411353921889@wrigleys.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/

view thread (2+ messages)

Message-ID: <202411120845.iyhet5dzacwy@alvherre.pgsql>
Permalink:  ../202411120845.iyhet5dzacwy@alvherre.pgsql/
Also on:    postgresql.org/message-id/202411120845.iyhet5dzacwy@alvherre.pgsql

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: alvherre@alvh.no-ip.org, tim.dadd@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: CREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ];
  In-Reply-To: <202411120845.iyhet5dzacwy@alvherre.pgsql>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox