Re: CTEs modifying the same table more than once - Mailing list pgsql-docs

From Marko Tiikkaja
Subject Re: CTEs modifying the same table more than once
Date
Msg-id 3a2cae10-2b5a-4f15-e257-0c985e423f0e@joh.to
Whole thread Raw
In response to CTEs modifying the same table more than once  (Pantelis Theodosiou <ypercube@gmail.com>)
Responses Re: CTEs modifying the same table more than once  (Pantelis Theodosiou <ypercube@gmail.com>)
List pgsql-docs
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


pgsql-docs by date:

Previous
From: Pantelis Theodosiou
Date:
Subject: CTEs modifying the same table more than once
Next
From: Pantelis Theodosiou
Date:
Subject: Re: CTEs modifying the same table more than once