diff options
Diffstat (limited to 'doc/src/sgml/indices.sgml')
| -rw-r--r-- | doc/src/sgml/indices.sgml | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 14a1aa56cb5..a57c5e2e1f4 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -639,7 +639,7 @@ CREATE INDEX test3_desc_index ON test3 (id DESC NULLS LAST); or the uniqueness of the combined values of more than one column. <synopsis> CREATE UNIQUE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable> (<replaceable>column</replaceable> <optional>, ...</optional>) -[ INCLUDE (<replaceable>column</replaceable> <optional>, ...</optional>) ]; +<optional> INCLUDE (<replaceable>column</replaceable> <optional>, ...</optional>) </optional>; </synopsis> Currently, only B-tree indexes can be declared unique. </para> @@ -648,9 +648,9 @@ CREATE UNIQUE INDEX <replaceable>name</replaceable> ON <replaceable>table</repla When an index is declared unique, multiple table rows with equal indexed values are not allowed. Null values are not considered equal. A multicolumn unique index will only reject cases where all - indexed columns are equal in multiple rows. Columns listed in the - <literal>INCLUDE</literal> clause aren't used to enforce constraints - (UNIQUE, PRIMARY KEY, etc). + indexed columns are equal. Columns listed in + the <literal>INCLUDE</literal> clause, if any, aren't considered when + determining whether index entries are equal. </para> <para> |