Am 13.09.2011 07:50, schrieb pasman pasmański:
In 8.4 this syntax is not implemented.
select * from ( update tbl set val = 1 where key in ( 1, 2, 3, 4, 5 ) returning * ) as x wouldn't work even in PG 9.1.So what data structure is coming out of an "update ... returning *" statement?
It obviously doesn't work like a subquery. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
