Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group