Re: SQL plan in functions

On Thu, Dec 18, 2008 at 9:18 AM, Julius Tuskenis
<julius(dot)tuskenis(at)gmail(dot)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