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

2008-05-31 Thread dvs
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 t

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

2008-05-30 Thread dvs
nytable where condition but this function is analog of "insert...returning" in any case Why analog work "better" then original? What is my mistake? (I dont want use functions here!) dvs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general