Joe,

> Never tried it, but is it possible to use a prepared statement inside a 
> PL/pgSQL function? In any case, you can in other PLs. And with library 
> preloading (starting in 7.4), the first call to other PLs is similar to 
> that of PL/pgSQL. See:
>    http://archives.postgresql.org/pgsql-patches/2003-07/msg00239.php

Not sure how useful it would be in my case; I'm using EXECUTE because I'm 
building a dynamic query based on user input, so the query plans would need 
to vary radically from run to run.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to