| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tomáš Greif <tomas(dot)greif(at)collectionspro(dot)eu> |
| Cc: | pgsql-docs <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: Add link to partial unique index from Constraints (5.3) |
| Date: | 2014-04-30 14:18:22 |
| Message-ID: | CA+TgmoaTtJk6ZR-RmxQ6enUfX3XkuvzyGNLutpZkwT5NWesT1w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Wed, Apr 9, 2014 at 8:17 AM, Tomáš Greif
<tomas(dot)greif(at)collectionspro(dot)eu> wrote:
> would it be good idea to add new paragraph 5.3.7 to chapter 5.3
> (Constraints) with at least information that there is something like partial
> unique index and link to chapter 11.8 (Partial Indexes)?
>
> Partial index can be used to enforce uniqueness in a way other constraints
> cannot provide. Currently, it not easy to find this type of constraint as
> not a lot of people would read through documentation on indexes when looking
> for constraints.
I think adding something to that chapter would be good.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2014-05-06 20:10:49 | Re: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation) |
| Previous Message | Tom Lane | 2014-04-25 14:33:34 | Re: 9.3 release notes and maintenance_work_mem |