diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-07-14 15:33:28 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-07-14 15:33:28 -0400 |
| commit | 4f63f6aae0cd2bbcbb18c43db79c0351a69f91ad (patch) | |
| tree | 391342606bd2b4108a70269c18fb0b1bd1977f23 | |
| parent | 6959e971b35e7e6e10d61b95699cec7985d053b1 (diff) | |
| download | postgresql-4f63f6aae0cd2bbcbb18c43db79c0351a69f91ad.tar.gz postgresql-4f63f6aae0cd2bbcbb18c43db79c0351a69f91ad.zip | |
doc: clarify that "excluded" ON CONFLICT is a single row
Original patch by David G. Johnston.
Reported-by: David G. Johnston
Discussion: https://postgr.es/m/CAKFQuwa4J0+WuO7kW1PLbjoEvzPN+Q_j+P2bXxNnCLaszY7ZdQ@mail.gmail.com
Backpatch-through: 10
| -rw-r--r-- | doc/src/sgml/ref/insert.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index 29e92546ef4..7cea70329e1 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -181,7 +181,7 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac provided, it completely hides the actual name of the table. This is particularly useful when <literal>ON CONFLICT DO UPDATE</literal> targets a table named <varname>excluded</varname>, since that will otherwise - be taken as the name of the special table representing rows proposed + be taken as the name of the special table representing the row proposed for insertion. </para> </listitem> @@ -401,7 +401,7 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac conflict. The <literal>SET</literal> and <literal>WHERE</literal> clauses in <literal>ON CONFLICT DO UPDATE</literal> have access to the existing row using the - table's name (or an alias), and to rows proposed for insertion + table's name (or an alias), and to the row proposed for insertion using the special <varname>excluded</varname> table. <literal>SELECT</literal> privilege is required on any column in the target table where corresponding <varname>excluded</varname> |