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?

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