diff options
| author | Simon Riggs | 2018-04-05 11:03:42 +0000 |
|---|---|---|
| committer | Simon Riggs | 2018-04-05 11:03:42 +0000 |
| commit | a5d86181ecc9c441d4c327771c43134de59549cd (patch) | |
| tree | 6c2761ff89b4fd1d1baad177ed66b47586d4151d | |
| parent | 17d8beb4f52599805283b1f2f49e02491656f7e1 (diff) | |
MERGE INSERT allows only one VALUES clause
Doc syntax and brief mention of restriction
| -rw-r--r-- | doc/src/sgml/ref/merge.sgml | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml index 0ca3d26ff48..31ba7a841d1 100644 --- a/doc/src/sgml/ref/merge.sgml +++ b/doc/src/sgml/ref/merge.sgml @@ -41,7 +41,7 @@ and <replaceable class="parameter">merge_insert</replaceable> is INSERT [( <replaceable class="parameter">column_name</replaceable> [, ...] )] [ OVERRIDING { SYSTEM | USER } VALUE ] -{ VALUES ( { <replaceable class="parameter">expression</replaceable> | DEFAULT } [, ...] ) | DEFAULT VALUES } +{ VALUES ( { <replaceable class="parameter">expression</replaceable> | DEFAULT } ) | DEFAULT VALUES } and <replaceable class="parameter">merge_update</replaceable> is @@ -285,6 +285,7 @@ DELETE <command>INSERT</command> actions cannot contain sub-selects. </para> <para> + Only one <literal>VALUES</literal> clause can be specified. The <literal>VALUES</literal> clause can only refer to columns from the source relation, since by definition there is no matching target row. </para> |