Hi,
today on IRC there was a strange problem shown. The small working example
looks like this:

x=# with x as (insert into a(t) values('1') returning *) select * from x;
 t
---
 1
(1 row)

x=# with x (insert into a(t) values('1') returning *) select * from x;
ERROR:  syntax error at or near "into"
LINE 1: with x (insert into a(t) values('1') returning *) select * f...
                       ^

The initial code was run on 9.2; I've checked that on 9.4devel.

The error message is really not useful, as there is missing "as" after
"with x". There is no problem with "into".

regards
Szymon

Reply via email to