Commitafc8ee1

committed

doc: clarify that "excluded" ON CONFLICT is a single row

Original patch by David G. Johnston.Reported-by: David G. JohnstonDiscussion:https://postgr.es/m/CAKFQuwa4J0+WuO7kW1PLbjoEvzPN+Q_j+P2bXxNnCLaszY7ZdQ@mail.gmail.comBackpatch-through: 10

1 parentac480b0 commitafc8ee1Copy full SHA for afc8ee1

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -182,7 +182,7 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac`
`182`	`182`	`provided, it completely hides the actual name of the table.`
`183`	`183`	`This is particularly useful when <literal>ON CONFLICT DO UPDATE</literal>`
`184`	`184`	`targets a table named <varname>excluded</varname>, since that will otherwise`
`185`		`- be taken as the name of the special table representingrows proposed`
	`185`	`+ be taken as the name of the special table representingthe row proposed`
`186`	`186`	`for insertion.`
`187`	`187`	`</para>`
`188`	`188`	`</listitem>`
`@@ -389,7 +389,7 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac`
`389`	`389`	`conflict. The <literal>SET</literal> and`
`390`	`390`	`<literal>WHERE</literal> clauses in <literal>ON CONFLICT DO`
`391`	`391`	`UPDATE</literal> have access to the existing row using the`
`392`		`- table's name (or an alias), and torows proposed for insertion`
	`392`	`+ table's name (or an alias), and tothe row proposed for insertion`
`393`	`393`	`using the special <varname>excluded</varname> table.`
`394`	`394`	`<literal>SELECT</literal> privilege is required on any column in the`
`395`	`395`	`target table where corresponding <varname>excluded</varname>`

Comments

(0)