On Monday, October 5, 2026, Carl.Weierstrass <
carl.weierstrass@googlemail.com> wrote:
but the more elegant version in one single statement results in a syntax error
begin;
insert into test2
delete from test1
where 1 = 1
returning *; --return deleted lines
commit;
psql:test.sql:32: FEHLER: Syntaxfehler bei »delete«
ZEILE 2: delete from test1
Is this a bug or a feature?
If you make something up that isn’t documented it shouldn’t work. You can call the inability to interpret random stuff you send to the server a feature if you need an apply a label.
You might want to look at the WITH clause of those commands to see how to go about combining multiple distinct commands into one execution correctly.
David J.
