Thread: pgsql: MERGE INSERT allows only one VALUES clause
MERGE INSERT allows only one VALUES clause Doc syntax and brief mention of restriction Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a5d86181ecc9c441d4c327771c43134de59549cd Modified Files -------------- doc/src/sgml/ref/merge.sgml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-)
>>>>> "Simon" == Simon Riggs <simon@2ndQuadrant.com> writes: Simon> MERGE INSERT allows only one VALUES clause That can't possibly be right; you've changed it to say that only one _expression_ (i.e. column) is allowed in the VALUES () list, not that only one _row_ is allowed. I think it was correct before. -- Andrew (irc:RhodiumToad)
On 5 April 2018 at 17:15, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote: >>>>>> "Simon" == Simon Riggs <simon@2ndQuadrant.com> writes: > > Simon> MERGE INSERT allows only one VALUES clause > > That can't possibly be right; you've changed it to say that only one > _expression_ (i.e. column) is allowed in the VALUES () list, not that > only one _row_ is allowed. I think it was correct before. Corrected, thanks -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services