diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-14 19:16:19 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-14 19:16:19 +0000 |
commit | 31176cd686f31dcb71392f6583f7b8d9cef63770 (patch) | |
tree | 27fefbaada5177e179c6cf8806be49dfe613d5f4 /doc/src/sgml/man7/CREATE_TABLE.7 | |
parent | Adding upstream version 16.2. (diff) | |
download | postgresql-16-upstream.tar.xz postgresql-16-upstream.zip |
Adding upstream version 16.3.upstream/16.3upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'doc/src/sgml/man7/CREATE_TABLE.7')
-rw-r--r-- | doc/src/sgml/man7/CREATE_TABLE.7 | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/man7/CREATE_TABLE.7 b/doc/src/sgml/man7/CREATE_TABLE.7 index ce895ce..0801d25 100644 --- a/doc/src/sgml/man7/CREATE_TABLE.7 +++ b/doc/src/sgml/man7/CREATE_TABLE.7 @@ -3,11 +3,11 @@ .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot <http://docbook.sf.net/> .\" Date: 2024 -.\" Manual: PostgreSQL 16.2 Documentation -.\" Source: PostgreSQL 16.2 +.\" Manual: PostgreSQL 16.3 Documentation +.\" Source: PostgreSQL 16.3 .\" Language: English .\" -.TH "CREATE TABLE" "7" "2024" "PostgreSQL 16.2" "PostgreSQL 16.2 Documentation" +.TH "CREATE TABLE" "7" "2024" "PostgreSQL 16.3" "PostgreSQL 16.3 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- @@ -114,7 +114,7 @@ WITH ( MODULUS \fInumeric_literal\fR, REMAINDER \fInumeric_literal\fR ) \fIexclude_element\fR in an EXCLUDE constraint is: -{ \fIcolumn_name\fR | ( \fIexpression\fR ) } [ \fIopclass\fR ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] +{ \fIcolumn_name\fR | ( \fIexpression\fR ) } [ COLLATE \fIcollation\fR ] [ \fIopclass\fR [ ( \fIopclass_parameter\fR = \fIvalue\fR [, \&.\&.\&. ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] \fIreferential_action\fR in a FOREIGN KEY/REFERENCES constraint is: @@ -745,13 +745,13 @@ UNIQUE constraint, although an ordinary unique constraint will be faster\&. However, exclusion constraints can specify constraints that are more general than simple equality\&. For example, you can specify a constraint that no two rows in the table contain overlapping circles (see Section\ \&8.8) by using the && -operator\&. +operator\&. The operator(s) are required to be commutative\&. .sp Exclusion constraints are implemented using an index, so each specified operator must be associated with an appropriate operator class (see Section\ \&11.10) for the index access method -\fIindex_method\fR\&. The operators are required to be commutative\&. Each +\fIindex_method\fR\&. Each \fIexclude_element\fR -can optionally specify an operator class and/or ordering options; these are described fully under +defines a column of the index, so it can optionally specify a collation, an operator class, operator class parameters, and/or ordering options; these are described fully under CREATE INDEX (\fBCREATE_INDEX\fR(7))\&. .sp The access method must support |