On 2016-10-01 13:13, Pantelis Theodosiou wrote:
> I answered that this is unpredictable behaviour but the docs state only the
> update-update and update-delete cases explicitly and the general wording is
> about 2 updates.
It's documented[1] behavior:
"All the statements are executed with the same snapshot (see Chapter
13), so they cannot "see" one another's effects on the target tables."
.m
[1] https://www.postgresql.org/docs/current/static/queries-with.html