Re: pgsql: MERGE INSERT allows only one VALUES clause

2018-04-05 Thread Simon Riggs
On 5 April 2018 at 17:15, Andrew Gierth  wrote:
>> "Simon" == Simon Riggs  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 Riggshttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



Re: pgsql: MERGE INSERT allows only one VALUES clause

2018-04-05 Thread Andrew Gierth
> "Simon" == Simon Riggs  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)



pgsql: MERGE INSERT allows only one VALUES clause

2018-04-05 Thread Simon Riggs
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(-)