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