On Monday, October 5, 2026, Carl.Weierstrass < [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. David J.
