On Thu, Dec 18, 2008 at 9:18 AM, Julius Tuskenis
<julius.tuske...@gmail.com> wrote:
> Hello, list.
>
> I have a function witch returns record set. What troubles me is that
> depending on parameters I pass to this function  the execution time varies
> greatly. On the other hand if I execute the query (not the function) with
> pgAdmin  - it gives results quickly.
> In previous post You helped me realize, that the problem was because the
> function has only one plan of SQL inside no matter the parameters values. Is
> there a way to order postgres to check the plan each time the function is
> called?

use EXECUTE 'query' .



-- 
GJ

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to