Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WfVL9-0004pt-63 for pgsql-docs@arkaria.postgresql.org; Wed, 30 Apr 2014 14:18:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WfVL8-0007Q1-Me for pgsql-docs@arkaria.postgresql.org; Wed, 30 Apr 2014 14:18:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WfVL8-0007Pu-66 for pgsql-docs@postgresql.org; Wed, 30 Apr 2014 14:18:26 +0000 Received: from mail-we0-x22b.google.com ([2a00:1450:400c:c03::22b]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WfVL4-0007Cx-O3 for pgsql-docs@postgresql.org; Wed, 30 Apr 2014 14:18:25 +0000 Received: by mail-we0-f171.google.com with SMTP id w62so860588wes.2 for ; Wed, 30 Apr 2014 07:18:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; bh=K1siLjg2E/R0txusIRq8rZRoTVYkBRPLWeKnal7jwBo=; b=H4twbWgFRX7U35qNnIq0WU4pPM7+G4PWSTBPph+7+FIw5dCAt/55NJVKPV/IiD73M+ d1XLCGNhuB9xr+TwX6TgOTlfJoHJ+YRLVfUCu1iBWSlz7Vq/BNYx8A5aQC1U9UNsSDcE ySvSOXWE7ltTluwFNOKkQMd0gbSCVxAXZBwzht/BNuqTpSgGtTTFvxxh5DwRcIdd7hEQ SxH147Ll//qlaBjsHytR9CvfYoejs94FesupN1qvKEpu8bePOyRgBdXB34nx3YllAGej 1lWJ/f9UnRdU0Y4KxM/Yr/XNHt+aflFRPimD+HT4ROUgiMhtkIlNpfPlrJ0bN6oAJ5pn DjlA== MIME-Version: 1.0 X-Received: by 10.180.97.41 with SMTP id dx9mr3986969wib.28.1398867502209; Wed, 30 Apr 2014 07:18:22 -0700 (PDT) Received: by 10.227.234.209 with HTTP; Wed, 30 Apr 2014 07:18:22 -0700 (PDT) In-Reply-To: References: Date: Wed, 30 Apr 2014 10:18:22 -0400 Message-ID: Subject: Re: Add link to partial unique index from Constraints (5.3) From: Robert Haas To: =?UTF-8?B?VG9tw6HFoSBHcmVpZg==?= Cc: pgsql-docs Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Wed, Apr 9, 2014 at 8:17 AM, Tom=C3=A1=C5=A1 Greif 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 part= ial > 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 look= ing > for constraints. I think adding something to that chapter would be good. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs