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

Commitfe7fc52

Browse files
committed
Improve docs for the new INCLUDE directive in CREATE/ALTER TABLE.
Author: Michael PaquierDiscussion:https://www.postgresql.org/message-id/20180411082020.GD19732%40paquier.xyz
1 parent55d26ff commitfe7fc52

File tree

2 files changed

+4
-2
lines changed

2 files changed

+4
-2
lines changed

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

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -125,6 +125,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
125125

126126
<phrase><replaceable class="parameter">index_parameters</replaceable> in <literal>UNIQUE</literal>, <literal>PRIMARY KEY</literal>, and <literal>EXCLUDE</literal> constraints are:</phrase>
127127

128+
[ INCLUDE ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) ]
128129
[ WITH ( <replaceable class="parameter">storage_parameter</replaceable> [= <replaceable class="parameter">value</replaceable>] [, ... ] ) ]
129130
[ USING INDEX TABLESPACE <replaceable class="parameter">tablespace_name</replaceable> ]
130131

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

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -73,8 +73,8 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
7373

7474
[ CONSTRAINT <replaceable class="parameter">constraint_name</replaceable> ]
7575
{ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] |
76-
UNIQUE ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) <replaceable class="parameter">index_parameters</replaceable><optional> INCLUDE (<replaceable class="parameter">column_name</replaceable> [, ...]) </optional>|
77-
PRIMARY KEY ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) <replaceable class="parameter">index_parameters</replaceable><optional> INCLUDE (<replaceable class="parameter">column_name</replaceable> [, ...]) </optional>|
76+
UNIQUE ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) <replaceable class="parameter">index_parameters</replaceable> |
77+
PRIMARY KEY ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) <replaceable class="parameter">index_parameters</replaceable> |
7878
EXCLUDE [ USING <replaceable class="parameter">index_method</replaceable> ] ( <replaceable class="parameter">exclude_element</replaceable> WITH <replaceable class="parameter">operator</replaceable> [, ... ] ) <replaceable class="parameter">index_parameters</replaceable> [ WHERE ( <replaceable class="parameter">predicate</replaceable> ) ] |
7979
FOREIGN KEY ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) REFERENCES <replaceable class="parameter">reftable</replaceable> [ ( <replaceable class="parameter">refcolumn</replaceable> [, ... ] ) ]
8080
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE <replaceable class="parameter">action</replaceable> ] [ ON UPDATE <replaceable class="parameter">action</replaceable> ] }
@@ -93,6 +93,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
9393

9494
<phrase><replaceable class="parameter">index_parameters</replaceable> in <literal>UNIQUE</literal>, <literal>PRIMARY KEY</literal>, and <literal>EXCLUDE</literal> constraints are:</phrase>
9595

96+
[ INCLUDE ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) ]
9697
[ WITH ( <replaceable class="parameter">storage_parameter</replaceable> [= <replaceable class="parameter">value</replaceable>] [, ... ] ) ]
9798
[ USING INDEX TABLESPACE <replaceable class="parameter">tablespace_name</replaceable> ]
9899

0 commit comments

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