"frank" <frank(at)ros-i(dot)com> 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