"Richard Broersma" <richard.broersma@gmail.com> writes:
> UPDATE Foo
> SET ( a, b, c, ..., n ) = ( SELECT newA, newB, newC, ..., newN
> FROM Bar WHERE foo.id = Bar.id )
> Any thoughts on this?
It's been on the TODO list for quite some time:
http://wiki.postgresql.org/wiki/Todo#UPDATE
regards, tom lane