Re: [GENERAL] cannot use result of (insert .. returning)

[Tino Wildenhain]

dvs wrote:

Hello,

I need to use query like:

but it say
   ERROR: syntax error at or near "into"

,c from anytable where condition

did you try with:

select (insert into test (a) values (x) returning b) query_a JOIN c ON ... ?

Tino.

smime.p7s
Description: S/MIME Cryptographic Signature