Use select and update together - Mailing list pgsql-sql

Hi, this is my first on this list.

I can't understand where my problem in PG 8.4.

CREATE TABLE tbl( KEY  int, val int);

Update query like:

UPDATE tbl SET val = 1            WHERE KEY = any('{0,1,2,3,4,5}'::int[])        returning key;

work well. But any try to wrap it in select query like:

SELECT (        UPDATE tbl SET val = 1            WHERE KEY = any('{0,1,2,3,4,5}'::int[])        returning key
);

cause syntax error. Is any query of such type (update warped into
select) is possible?


Best regards, Kuzikov Borys