On 10/5/26 7:32 AM, David G. Johnston wrote:
On Monday, October 5, 2026, Carl.Weierstrass
<[email protected]
<mailto:[email protected]>> 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.
In particular:
https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-MODIFYING
David J.
--
Adrian Klaver
[email protected]
