"Richard Broersma" <[EMAIL PROTECTED]> 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
Regarding: row-wise update.
In a previous thread:
http://archives.postgresql.org/pgsql-sql/2008-08/msg00122.php
it was mentioned that the "UPDATE ... SET ... FROM ... WHERE" syntax
is an extension. (an extension employed by many other db flavors.)
This creates a problems since each db flavor is