On Wed, Jan 10, 2024 at 09:06:31AM -0700, David G. Johnston wrote: > It is mostly documented. > > https://www.postgresql.org/docs/current/queries-with.html# > QUERIES-WITH-MODIFYING > """ > Only one of the modifications takes place, but it is not easy (and sometimes > not possible) to reliably predict which one. > ... > In particular avoid writing WITH sub-statements that could affect the same rows > changed by the main statement or a sibling sub-statement. The effects of such a > statement will not be predictable. > """ > > Yes, an error would be nice, but the effort put forth stops at unpredictable, > and saying just don't do it. Oh, good to know. :-) -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
