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

Commit5fe7bcc

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 parentf700e7d commit5fe7bcc

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
@@ -132,7 +132,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
132132

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

135-
{ <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ <replaceable class="parameter">opclass</replaceable> ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
135+
{ <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 } ]
136136
</synopsis>
137137
</refsynopsisdiv>
138138

‎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
</synopsis>
109109

110110
</refsynopsisdiv>
@@ -998,6 +998,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
998998
no two rows in the table contain overlapping circles
999999
(see <xref linkend="datatype-geometric"/>) by using the
10001000
<literal>&amp;&amp;</literal> operator.
1001+
The operator(s) are required to be commutative.
10011002
</para>
10021003

10031004
<para>
@@ -1006,11 +1007,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
10061007
appropriate operator class
10071008
(see <xref linkend="indexes-opclass"/>) for the index access
10081009
method <replaceable>index_method</replaceable>.
1009-
The operators are required to be commutative.
10101010
Each <replaceable class="parameter">exclude_element</replaceable>
1011-
can optionally specify an operator class and/or ordering options;
1012-
these are described fully under
1013-
<xref linkend="sql-createindex"/>.
1011+
defines a column of the index, so it can optionally specify a collation,
1012+
an operator class, operator class parameters, and/or ordering options;
1013+
these are described fully under<xref linkend="sql-createindex"/>.
10141014
</para>
10151015

10161016
<para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp