Re: Use select and update together

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.