Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: YasonTR <yasontr(at)protonmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10
Date: 2017-10-24 15:07:45
Message-ID: CAKFQuwYLcxGUtBJEEuUUo=NZ-KDNyuB_DacaPV=0csXjoBLbXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Oct 24, 2017 at 7:55 AM, YasonTR <yasontr(at)protonmail(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-10-24 15:21:26 Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10
Previous Message YasonTR 2017-10-24 14:55:10 Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10