summaryrefslogtreecommitdiffstats
path: root/doc/src/sgml/man7/CREATE_TABLE.7
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-14 19:16:19 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-14 19:16:19 +0000
commit31176cd686f31dcb71392f6583f7b8d9cef63770 (patch)
tree27fefbaada5177e179c6cf8806be49dfe613d5f4 /doc/src/sgml/man7/CREATE_TABLE.7
parentAdding upstream version 16.2. (diff)
downloadpostgresql-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.714
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