Re: Support UPDATE table SET(*)=... - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: Support UPDATE table SET(*)=...
Date
Msg-id 54412DD5.3090803@joh.to
Whole thread Raw
In response to Re: Support UPDATE table SET(*)=...  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Support UPDATE table SET(*)=...
List pgsql-hackers
On 10/17/14 4:15 PM, Merlin Moncure wrote:
> Any particular reason why you couldn't have just done:
>
> UPDATE table1 SET * = a,b,c, ...

That just looks wrong to me.  I'd prefer  (*) = ..  over that any day.

> UPDATE table1 t SET t = (SELECT (a,b,c)::t FROM...);
>
> seems cleaner than the proposed syntax for row assignment.  Tom
> objected though IIRC.

I don't know about Tom, but I didn't like that: 
http://www.postgresql.org/message-id/5364C982.7060003@joh.to


.marko



pgsql-hackers by date:

Previous
From: Atri Sharma
Date:
Subject: Re: Support UPDATE table SET(*)=...
Next
From: Merlin Moncure
Date:
Subject: Re: Support UPDATE table SET(*)=...