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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
