Re: cannot use result of (insert .. returning)

From: "dvs" <dvs(at)fon(dot)kamchatka(dot)ru>
To: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: cannot use result of (insert .. returning)
Date: 2008-05-31 08:29:32
Message-ID: 012301c8c2f8$77be7e70$0e09a8c0@dvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> 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...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Kohll 2008-05-31 12:19:33 Re: Mediawiki 1.10 and PG 8.3 upgrade
Previous Message Tino Wildenhain 2008-05-31 06:53:31 Re: cannot use result of (insert .. returning)