Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7969=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WY5La-00035P-ET
 for pgsql-docs@arkaria.postgresql.org; Thu, 10 Apr 2014 03:08:14 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7969=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WY5LZ-0001tq-Tx
 for pgsql-docs@arkaria.postgresql.org; Thu, 10 Apr 2014 03:08:13 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tomas.greif@collectionspro.eu>) id 1WXrS9-0001gy-VI
 for pgsql-docs@postgresql.org; Wed, 09 Apr 2014 12:18:06 +0000
Received: from atlantis186.vshosting.cz ([78.24.9.186]
 helo=atlantis.vshosting.cz)
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tomas.greif@collectionspro.eu>) id 1WXrS1-0004Zn-VB
 for pgsql-docs@postgresql.org; Wed, 09 Apr 2014 12:18:05 +0000
Received: from atlantis.vshosting.cz (localhost [127.0.0.1])
 by atlantis.vshosting.cz (Postfix) with ESMTP id 25E6523412E7
 for <pgsql-docs@postgresql.org>; Wed,  9 Apr 2014 14:18:00 +0200 (CEST)
Received: from mail-ve0-f174.google.com (mail-ve0-f174.google.com
 [209.85.128.174]) by atlantis.vshosting.cz (Postfix) with ESMTPSA
 for <pgsql-docs@postgresql.org>; Wed,  9 Apr 2014 14:18:00 +0200 (CEST)
Received: by mail-ve0-f174.google.com with SMTP id oz11so1936319veb.19
 for <pgsql-docs@postgresql.org>; Wed, 09 Apr 2014 05:17:54 -0700 (PDT)
X-Received: by 10.58.185.145 with SMTP id fc17mr8892573vec.14.1397045874144;
 Wed, 09 Apr 2014 05:17:54 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.220.20.9 with HTTP; Wed, 9 Apr 2014 05:17:34 -0700 (PDT)
From: =?UTF-8?B?VG9tw6HFoSBHcmVpZg==?= <tomas.greif@collectionspro.eu>
Date: Wed, 9 Apr 2014 14:17:34 +0200
Message-ID: 
 <CAGKU+8Ds=3Co=mcf1VN+3kGszDaoBj7Q17c6bpM43Z+iYaHL2w@mail.gmail.com>
Subject: Add link to partial unique index from Constraints (5.3)
To: pgsql-docs@postgresql.org
Content-Type: multipart/alternative; boundary=047d7b67052f103d5e04f69b1774
X-Pg-Spam-Score: 0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--047d7b67052f103d5e04f69b1774
Content-Type: text/plain; charset=UTF-8

Hi,

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.

Regards,

Tomas

--047d7b67052f103d5e04f69b1774
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>would it be good idea to add new pa=
ragraph 5.3.7 to chapter 5.3 (Constraints) with at least information that t=
here is something like partial unique index and link to chapter 11.8 (Parti=
al Indexes)?=C2=A0</div>

<div><br></div><div>Partial index can be used to enforce uniqueness in a wa=
y other constraints cannot provide. Currently, it not easy to find this typ=
e of constraint as not a lot of people would read through documentation on =
indexes when looking for constraints.</div>

<div><br></div><div>Regards,</div><div><br></div><div>Tomas</div></div>

--047d7b67052f103d5e04f69b1774--