Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commite2663a6

Browse files
committed
Doc: update documentation about EXCLUDE constraint elements.
What the documentation calls an exclude_element is an index_elemaccording to gram.y, and it allows all the same options thata CREATE INDEX column specification does. The COLLATE patchneglected to update the CREATE/ALTER TABLE docs about that,and later the opclass-parameters patch made the same oversight.Add those options to the syntax synopses, and polish theassociated text a bit.Back-patch to v13 where opclass parameters came in. We couldupdate v12 with just the COLLATE omission, but it doesn't quiteseem worth the trouble at this point.Shihao Zhong, reviewed by Daniel Vérité, Shubham Khanna and myselfDiscussion:https://postgr.es/m/CAGRkXqShbVyB8E3gapfdtuwiWTiK=Q67Qb9qwxu=+-w0w46EBA@mail.gmail.com
1 parenta9c20c8 commite2663a6

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

‎doc/src/sgml/ref/alter_table.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -134,7 +134,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
134134

135135
<phrase><replaceable class="parameter">exclude_element</replaceable> in an <literal>EXCLUDE</literal> constraint is:</phrase>
136136

137-
{ <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ <replaceable class="parameter">opclass</replaceable> ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
137+
{ <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [COLLATE<replaceable class="parameter">collation</replaceable> ] [ <replaceable class="parameter">opclass</replaceable> [ ( <replaceable class="parameter">opclass_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
138138

139139
<phrase><replaceable class="parameter">referential_action</replaceable> in a <literal>FOREIGN KEY</literal>/<literal>REFERENCES</literal> constraint is:</phrase>
140140

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -104,7 +104,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
104104

105105
<phrase><replaceable class="parameter">exclude_element</replaceable> in an <literal>EXCLUDE</literal> constraint is:</phrase>
106106

107-
{ <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ <replaceable class="parameter">opclass</replaceable> ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
107+
{ <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [COLLATE<replaceable class="parameter">collation</replaceable> ] [ <replaceable class="parameter">opclass</replaceable> [ ( <replaceable class="parameter">opclass_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
108108

109109
<phrase><replaceable class="parameter">referential_action</replaceable> in a <literal>FOREIGN KEY</literal>/<literal>REFERENCES</literal> constraint is:</phrase>
110110

@@ -1057,6 +1057,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
10571057
no two rows in the table contain overlapping circles
10581058
(see <xref linkend="datatype-geometric"/>) by using the
10591059
<literal>&amp;&amp;</literal> operator.
1060+
The operator(s) are required to be commutative.
10601061
</para>
10611062

10621063
<para>
@@ -1065,11 +1066,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
10651066
appropriate operator class
10661067
(see <xref linkend="indexes-opclass"/>) for the index access
10671068
method <replaceable>index_method</replaceable>.
1068-
The operators are required to be commutative.
10691069
Each <replaceable class="parameter">exclude_element</replaceable>
1070-
can optionally specify an operator class and/or ordering options;
1071-
these are described fully under
1072-
<xref linkend="sql-createindex"/>.
1070+
defines a column of the index, so it can optionally specify a collation,
1071+
an operator class, operator class parameters, and/or ordering options;
1072+
these are described fully under<xref linkend="sql-createindex"/>.
10731073
</para>
10741074

10751075
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp