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

Commit7a05413

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 parent3d5a9bb commit7a05413

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

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

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

‎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>
@@ -1047,6 +1047,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
10471047
no two rows in the table contain overlapping circles
10481048
(see <xref linkend="datatype-geometric"/>) by using the
10491049
<literal>&amp;&amp;</literal> operator.
1050+
The operator(s) are required to be commutative.
10501051
</para>
10511052

10521053
<para>
@@ -1055,11 +1056,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
10551056
appropriate operator class
10561057
(see <xref linkend="indexes-opclass"/>) for the index access
10571058
method <replaceable>index_method</replaceable>.
1058-
The operators are required to be commutative.
10591059
Each <replaceable class="parameter">exclude_element</replaceable>
1060-
can optionally specify an operator class and/or ordering options;
1061-
these are described fully under
1062-
<xref linkend="sql-createindex"/>.
1060+
defines a column of the index, so it can optionally specify a collation,
1061+
an operator class, operator class parameters, and/or ordering options;
1062+
these are described fully under<xref linkend="sql-createindex"/>.
10631063
</para>
10641064

10651065
<para>

0 commit comments

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