Hitoshi Harada <umi.tanuki@gmail.com> writes:
> 2009/5/27 Tom Lane <tgl@sss.pgh.pa.us>:
>> I could still see doing what I mentioned in the prior message, which is
>> to flatten CTEs as if they are plain sub-selects when
>>
>> 1. they are non-recursive,
>> 2. they are referenced only once, and
>> 3. they contain no volatile functions.
> And 4. only if the sub-selects use index scan? Or in other cases would
> it be effective?
Uh ... you've got the causality backwards, and I don't see the point of
such a restriction anyway.
regards, tom lane