David Fetter <david(at)fetter(dot)org> writes:
> What's the effect, if any, on CTEs that depend on each other
> explicitly?
An error. That would require mutual recursion, which we don't
support for the SELECT case let alone data-modifying statements.
regards, tom lane