Commit4f63f6a

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 parent6959e97 commit4f63f6aCopy full SHA for 4f63f6a

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

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

Comments

(0)