[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] cannot use result of (insert .. returning)
From:       "dvs" <dvs () fon ! kamchatka ! ru>
Date:       2008-05-31 8:29:32
Message-ID: 012301c8c2f8$77be7e70$0e09a8c0 () dvs
[Download RAW message or body]

>> I need to use query like:
>>    ,c from anytable where condition
>> but it say
>>    ERROR: syntax error at or near "into"
>
> did you try with:
> select (insert into test (a) values (x) returning b) query_a JOIN c ON ... 
> ?

you about
   select * from (insert into test (a) values (x) returning b) z
?
it get the same error...


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]