Re: wCTE behaviour - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: wCTE behaviour
Date
Msg-id 92BE7A00-2E86-40C8-B94E-4328DA6E68C7@kineticode.com
Whole thread Raw
In response to Re: wCTE behaviour  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: wCTE behaviour
List pgsql-hackers
On Nov 11, 2010, at 9:13 AM, Tom Lane wrote:

> If we establish a precedent that WITHs can be thought of as executing
> before the main command, we will eventually have to de-optimize existing
> WITH behavior.  Or else make up reasons why the inconsistency is okay in
> some cases and not others, but that will definitely be a case of
> rationalizing after the fact.

I can see that, but if one can't see the result of the write, or can't determine whether or not it will be visible in
advance,what's the point of writeable CTEs? 

Best,

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: wCTE behaviour
Next
From: Mark Cave-Ayland
Date:
Subject: Re: improved parallel make support