Re: [GENERAL] Feature Request: additional extension to UPDATE

2008-08-28 Thread Tom Lane
"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

[GENERAL] Feature Request: additional extension to UPDATE

2008-08-27 Thread Richard Broersma
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