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