Postgres Pro
Downloads
Home   >   mailing lists

Re: cannot use result of (insert .. returning) - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: cannot use result of (insert .. returning)
Date
Msg-id 4840F5EB.4000301@wildenhain.de
Whole thread Raw
In response to cannot use result of (insert .. returning)  ("dvs" <dvs@fon.kamchatka.ru>)
List pgsql-general
Tree view 
dvs wrote:
> Hello,
>
> 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 ... ?

Tino.
Attachment

pgsql-general by date:

Previous
From: Marc Weber
Date:
Subject: Re: Howto implement sxntax and semantic complie time chock for
Next
From: "dvs"
Date:
Subject: Re: cannot use result of (insert .. returning)