Re: [SQL] SQL Functions vs PL/PgSQL

2003-02-13 Thread Tom Lane
Roberto Mello [EMAIL PROTECTED] writes: On Thu, Feb 13, 2003 at 09:02:05AM -0800, Josh Berkus wrote: Unless you know something I don't, I do not believe that PL/pgSQL stores execution plans for functions. AFAIK execution plans for PL/pgSQL functions were cached once per backend. No? Yes.

Re: [SQL] SQL Functions vs PL/PgSQL

2003-02-13 Thread Josh Berkus
Johnny, Does postgres store execution plan's for user-defined SQL functions as the PL/pgSQL interpreter does. And if so - will this only be prepared after an initial call to the function? Can't seem to find this information in the docs!? Thanks, Unless you know something I don't, I do not