postgres.git / summary / log / commit / refs

commit    646deb603e0846d1efd4da84df412963dda68eec
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Wed Sep 03 18:34:46 2014 +0000
First released in: 9.5.0, 9.4.0

    Document use of partial indexes for partial unique constraints
    
    Report by Tomáš Greif
    
    Backpatch through 9.4


 doc/src/sgml/ddl.sgml | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 8ace8bd3a25..ceb83798c89 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -546,7 +546,9 @@ CREATE TABLE products (
 
    <para>
     Adding a unique constraint will automatically create a unique btree
-    index on the column or group of columns used in the constraint.
+    index on the column or group of columns used in the constraint. 
+    A uniqueness constraint on only some rows can be enforced by creating
+    a <link linkend="indexes-partial">partial index</link>.
    </para>
 
    <indexterm>


[parent: 6ea591ed4619]