diff options
| author | Bruce Momjian <bruce@momjian.us> | 2014-09-03 14:32:57 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2014-09-03 14:32:57 -0400 |
| commit | 4b224011751d1d4a300a0a179fc006658c6868a3 (patch) | |
| tree | 044c6f43a0ebcbf33adb8122e26c58629d8884df | |
| parent | 4011f8c98bd8bb67715449d2db5fc97dffa6a41f (diff) | |
| download | postgresql-4b224011751d1d4a300a0a179fc006658c6868a3.tar.gz postgresql-4b224011751d1d4a300a0a179fc006658c6868a3.zip | |
Document use of partial indexes for partial unique constraints
Report by Tomáš Greif
Backpatch through 9.4
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 0fcd9f87062..c07f5a203dd 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> |