Re: subselects vs WITH in views

On Tue, Feb 19, 2013 at 1:02 AM, Albe Laurenz <laurenz.albe@wien.gv.at>wrote:

> Joe Van Dyk wrote:
> > My assumption was that WITH acted just like subselects, but apparently
> they don't? Using WITH doesn't
> > use the expected index.
>
> Currently WITH acts as an "optimization fence", that means
> that means that the planner won't move conditions into or
> out of the WITH query.


Where's the best place to read up on this?

Thanks,
Joe