Hitoshi Harada <umi.tan...@gmail.com> writes:
> 2009/5/27 Tom Lane <t...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
