On Thu, Nov 22, 2012 at 7:42 AM, Jeremy Harris <jgh(at)wizmail(dot)org> wrote:
> On 22/11/2012 00:08, Craig Ringer wrote:
>>
>> WITH
>> FENCE foo AS (SELECT ...),
>> bar AS (SELECT ...)
>> SELECT * FROM bar;
>>
>> Are we fencing just foo? Or all expressions?
>>
>
> WITH foo AS (FENCED SELECT ...),
> bar AS (SELECT ...),
> SELECT ... ;
I would much rather see 'MATERIALIZE' instead of 'FENCED', unless the
by the latter you mean to forbid *all* optimizations, whereas with the
latter the meaning is pretty clear.
--
Jon