Re: [PERFORM] View vs Stored Proc Performance

2009-09-12 Thread Dimitri Fontaine
Merlin Moncure 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 t

Re: [PERFORM] View vs Stored Proc Performance

2009-09-12 Thread Merlin Moncure
On Sat, Sep 12, 2009 at 7:51 AM, Dimitri Fontaine wrote: > Merlin Moncure 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 th