[SQL] Use select and update together

[Boris]

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

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