Already on TODO, your name added.
---------------------------------------------------------------------------
Neil Conway wrote:
> On Thu, 2002-02-21 at 23:11, Tom Lane wrote:
> > Neil Conway <nconway@klamath.dyndns.org> writes:
> > > On Thu, 2002-02-21 at 22:15, Tom Lane wrote:
> > >> I believe that SQL-language functions don't have any such optimization
> > >> at all :-( ... I think they are re-parsed and re-planned from scratch
> > >> on each call.
> >
> > > Would it be possible to enhance SQL-language functions to cache their
> > > query plan?
> >
> > Certainly; if plpgsql can do it, so can SQL functions. You could even
> > steal (or better, find a way to share) a lot of the code from plpgsql.
> > But no one's gotten around to it.
>
> Okay, I'll take a look at this and see if I can implement it.
>
> Bruce, can you add this to do the TODO list (it may be there already, I
> just couldn't see it), and add me as responsible for it? Thanks.
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilconway@rogers.com>
> PGP Key ID: DB3C29FC
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
