Commita5d8618

committed

MERGE INSERT allows only one VALUES clause

Doc syntax and brief mention of restriction

1 parent17d8beb commita5d8618Copy full SHA for a5d8618

File tree

-1

lines changed

-1

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -41,7 +41,7 @@ and <replaceable class="parameter">merge_insert</replaceable> is`
`41`	`41`
`42`	`42`	`INSERT [( <replaceable class="parameter">column_name</replaceable> [, ...] )]`
`43`	`43`	`[ OVERRIDING { SYSTEM \| USER } VALUE ]`
`44`		`-{ VALUES ( { <replaceable class="parameter">expression</replaceable> \| DEFAULT }[, ...]) \| DEFAULT VALUES }`
	`44`	`+{ VALUES ( { <replaceable class="parameter">expression</replaceable> \| DEFAULT } ) \| DEFAULT VALUES }`
`45`	`45`
`46`	`46`	`and <replaceable class="parameter">merge_update</replaceable> is`
`47`	`47`
`@@ -285,6 +285,7 @@ DELETE`
`285`	`285`	`<command>INSERT</command> actions cannot contain sub-selects.`
`286`	`286`	`</para>`
`287`	`287`	`<para>`
	`288`	`+ Only one <literal>VALUES</literal> clause can be specified.`
`288`	`289`	`The <literal>VALUES</literal> clause can only refer to columns from`
`289`	`290`	`the source relation, since by definition there is no matching target row.`
`290`	`291`	`</para>`

Comments

(0)