"frank" <[email protected]> wrote: > WHERE upper("thisColumn") like $1 The function's plan is kept from one execution to another, and it can't know what will be in the first parameter -- perhaps '%X%'? If you build up the statement in a string and EXECUTE it, you might get the desired behavior. Anyway, next time you have an issue like this, please post to the performance list; this is not a bug. -Kevin
-- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
