Re: bug or feature

On 10/5/26 7:32 AM, David G. Johnston wrote:
> On Monday, October 5, 2026, Carl.Weierstrass
> <carl(dot)weierstrass(at)googlemail(dot)com
> <mailto:carl(dot)weierstrass(at)googlemail(dot)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.

In particular:

https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-MODIFYING

>
> David J.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com