[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

Re: [SQL] Use select and update together

[pasman pasmański]

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[])
>  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
>


-- 

pasman

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