From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: m.matin.agh@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Example for Unique Partial Indexes
Date: Tue, 07 Nov 2023 12:08:33 -0500
Message-ID: <144516.1699376913@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwYTZh9W-PPiLQ5uCEggB7ZNfFtr_e+Vc17apPUw6T833w@mail.gmail.com>
References: <169936161918.1769272.9365256195677055160@wrigleys.postgresql.org>
<CAKFQuwYTZh9W-PPiLQ5uCEggB7ZNfFtr_e+Vc17apPUw6T833w@mail.gmail.com>
"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
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: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, m.matin.agh@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Example for Unique Partial Indexes
In-Reply-To: <144516.1699376913@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox