Re: CTEs modifying the same table more than once

But surely it wouldn't hurt to add the 2 cases (insert-update, insert-delete) in the last paragraph. I mean the update-delete is also explained by the same reason.

> Trying to update the same row twice in a single statement is not supported. Only one of the modifications takes place, but it is not easy (and sometimes not possible) to reliably predict which one. This also applies to deleting a row that was already updated in the same statement: only the update is performed. Therefore you should generally avoid trying to modify a single row twice in a single statement. 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.