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:
In 8.4 this syntax is not implemented.
2011/9/12, 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[])
>
