Hi,
imagine a simple table with 1 row
=# table tf;
i | x
---+----
1 | xx
(1 row)
And this query:
with x as (update tf set i=i+1 returning *)
, y as (update tf set x=x||'yy' returning *)
select * from x,y;
My PG14 gives this result
i | x | i | x
---+---+---+---
(0 rows)
To me that was a bit surprising. I would have expected it to fail with
something like "can't update the same row twice in the same command".
If I check the table content after the query I see the i=i+1 part was
executed.
Is this expected behavior?
Thanks,
Torsten