Re: SQL plan in functions

Thank you Andreas and Grzegorz. It worked!

While experimenting I found that if I wright FOR rec IN EXECUTE 'my sql'
LOOP ......  its OK, but If I wright RETURN QUERY EXECUTE 'my sql' I get
syntax error. Is it a bug?

Julius Tuskenis



A. Kretschmer rašė:
> In response to Julius Tuskenis :
>
>> 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?
>>
>
> Sure, use EXECUTE 'your sql' inside the function to force the planner to
> generate a new plan depending on the current parameters.
>
>
> Regards, Andreas
>