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