On 13 mar 2006, at 11.35, Helge Elvik wrote:
> Is there any way for me to force plpgsql not to use a cached query
> plan, but instead figure out what’s best based on the LIKE-string
> that actually get passed to the function?
You can build the query as a string and EXECUTE it. This will force a
new plan to be prepared.
http://www.postgresql.org/docs/8.1/interactive/plpgsql-
statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
Sincerely,
Niklas Johansson