Re: SQL Functions vs PL/PgSQL

Of course what I meant was if postgres stores execution plans for queries in user-defined SQL functions. From the docs I can see that PL/PgSQL uses the SPI-interface to create and store execution plans for queries for each connection. But I'll use the PREPARE function like Thomasz Myrta suggested.

/Johnny

----- Original Message -----
From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Johnny Kristensen" <johnnybo1(at)mail(dot)tele(dot)dk>; <pgsql-sql(at)postgresql(dot)org>
Sent: Thursday, February 13, 2003 6:02 PM
Subject: Re: [SQL] SQL Functions vs PL/PgSQL

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 believe that PL/pgSQL stores
execution plans for functions.

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)