postgres.git / summary / log / commit / refs

commit    a5d86181ecc9c441d4c327771c43134de59549cd
Author:   Simon Riggs <simon@2ndQuadrant.com>
Date:     Thu Apr 05 11:03:42 2018 +0000
First released in: master (reverted before release)
Reverted by: 08ea7a2291db (in 11.0)

    MERGE INSERT allows only one VALUES clause
    
    Doc syntax and brief mention of restriction


 doc/src/sgml/ref/merge.sgml | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

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>


[parent: 17d8beb4f525]