Thursday, August 28, 2008

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

"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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: