Re: Supporting multiple column assignment in UPDATE (9.5 project) - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Supporting multiple column assignment in UPDATE (9.5 project)
Date
Msg-id 5367AF13.2060102@dunslane.net
Whole thread Raw
In response to Re: Supporting multiple column assignment in UPDATE (9.5 project)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Supporting multiple column assignment in UPDATE (9.5 project)  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On 05/05/2014 11:20 AM, Pavel Stehule wrote:
>
>
>
>     How about:
>     UPDATE foo SET (foo).* = (1,2,3);
>
>
> It is looking little bit strange
>
> I like previous proposal UPDATE foo SET foo = (1,2,3);
>

What if the table has a field called foo? Won't it then be ambiguous?

cheers

andrew



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: 9.4 release notes
Next
From: Merlin Moncure
Date:
Subject: Re: Supporting multiple column assignment in UPDATE (9.5 project)