Re: Example for Unique Partial Indexes

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: m(dot)matin(dot)agh(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Example for Unique Partial Indexes
Date: 2023-11-07 16:48:51
Message-ID: CAKFQuwYTZh9W-PPiLQ5uCEggB7ZNfFtr_e+Vc17apPUw6T833w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Tue, Nov 7, 2023, 09:25 PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/indexes-unique.html
> Description:
>
> I would like to request an improvement to the PostgreSQL documentation,
> specifically in the sections "11.6. Unique Indexes" and "11.8. Partial
> Indexes."
>
> 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.

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2023-11-07 17:08:33 Re: Example for Unique Partial Indexes
Previous Message PG Doc comments form 2023-11-07 12:53:39 Example for Unique Partial Indexes