From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: m.matin.agh@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Example for Unique Partial Indexes
In-reply-to: 
 <CAKFQuwYTZh9W-PPiLQ5uCEggB7ZNfFtr_e+Vc17apPUw6T833w@mail.gmail.com>
References: <169936161918.1769272.9365256195677055160@wrigleys.postgresql.org>
 <CAKFQuwYTZh9W-PPiLQ5uCEggB7ZNfFtr_e+Vc17apPUw6T833w@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 07 Nov 2023 09:48:51 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <144515.1699376913.1@sss.pgh.pa.us>
Date: Tue, 07 Nov 2023 12:08:33 -0500
Message-ID: <144516.1699376913@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/144516.1699376913%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tue, Nov 7, 2023, 09:25 PG Doc comments form <noreply@postgresql.org>
> wrote:
>> Currently, the documentation does not provide information on how to create
>> unique partial indexes. Unique partial indexes are valuable for enforcing
>> uniqueness of a column's value over a subset of a table

> 11.8 discusses this in detail including an example.  Maybe should add a
> forward reference from 11.6 though.

Yeah, AFAICS 11.8's coverage of this point is perfectly adequate.

I'm disinclined to add a forward reference, because 11.8 is the
first section that mentions partial indexes at all.  Somebody
reading the chapter in order would have no idea what we were
talking about.

			regards, tom lane