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

Commit2b18743

Browse files
committed
Doc: fix syntax synopsis for INSERT ... ON CONFLICT DO UPDATE.
Commit906bfca adjusted the syntax synopsis for UPDATE, but missedthe fact that the INSERT synopsis now contains a duplicate of that.In passing, improve wording and markup about using a table alias tododge the conflict with use of "excluded" as a special table name.
1 parenta5d4e3f commit2b18743

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

‎doc/src/sgml/ref/insert.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -36,7 +36,7 @@ INSERT INTO <replaceable class="PARAMETER">table_name</replaceable> [ AS <replac
3636

3737
DO NOTHING
3838
DO UPDATE SET { <replaceable class="PARAMETER">column_name</replaceable> = { <replaceable class="PARAMETER">expression</replaceable> | DEFAULT } |
39-
( <replaceable class="PARAMETER">column_name</replaceable> [, ...] ) = ( { <replaceable class="PARAMETER">expression</replaceable> | DEFAULT } [, ...] ) |
39+
( <replaceable class="PARAMETER">column_name</replaceable> [, ...] ) =[ ROW ]( { <replaceable class="PARAMETER">expression</replaceable> | DEFAULT } [, ...] ) |
4040
( <replaceable class="PARAMETER">column_name</replaceable> [, ...] ) = ( <replaceable class="PARAMETER">sub-SELECT</replaceable> )
4141
} [, ...]
4242
[ WHERE <replaceable class="PARAMETER">condition</replaceable> ]
@@ -174,9 +174,9 @@ INSERT INTO <replaceable class="PARAMETER">table_name</replaceable> [ AS <replac
174174
A substitute name for <replaceable
175175
class="PARAMETER">table_name</replaceable>. When an alias is
176176
provided, it completely hides the actual name of the table.
177-
This is particularly useful when <literal>ON CONFLICT DO
178-
UPDATE</literal>targets a table named excluded, since that's
179-
also the name of the special table representing rows proposed
177+
This is particularly useful when <literal>ON CONFLICT DO UPDATE</>
178+
targets a table named<varname>excluded</>, since that will otherwise
179+
be taken as the name of the special table representing rows proposed
180180
for insertion.
181181
</para>
182182
</listitem>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp