On Sat, Sep 12, 2009 at 7:51 AM, Dimitri Fontaine
<dfontaine(at)hi-media(dot)com> wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>> like joining the result to another table...the planner can see
>> 'through' the view, etc. in a function, the result is fetched first
>> and materialized without looking at the rest of the query.
>
> I though the planner would "see through" SQL language functions and
> inline them when possible, so they often can make for parametrized
> views...
It can happen for simple functions but often it will not. For views
it always happens.
merlin