Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] Possible regression in 'UPDATE ... SET () =' with just one single column/row value since v10 - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] Possible regression in 'UPDATE ... SET () =' with just one single column/row value since v10
Date
Msg-id CAKFQuwYLcxGUtBJEEuUUo=NZ-KDNyuB_DacaPV=0csXjoBLbXA@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10  (YasonTR <yasontr@protonmail.com>)
Responses Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
On Tue, Oct 24, 2017 at 7:55 AM, YasonTR <yasontr@protonmail.com> wrote:
Hi Tom,

I get your reference to the spec, but why is it working without ROW() when multiple columns are involved? For example: "UPDATE my_table SET (a, b) = (x, y)" works on v10 (afaik).


​https://www.postgresql.org/docs/10/static/sql-expressions.html#sql-syntax-row-constructors

"​The key word ROW is optional when there is more than one expression in the list."

David J.

pgsql-bugs by date:

Previous
From: YasonTR
Date:
Subject: Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10