Re: Supporting multiple column assignment in UPDATE (9.5 project)

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