Dan Sugalski <dan(at)sidhe(dot)org> writes:
> I'd figure, though, that since the parameters are being passed
> into PQexecParams basically to get them out of band so I don't have
> to deal with escaping, quoting, and suchlike things, that the
> optimizer would look at things *after* the substitution was done.
You'd figure wrong :-(. The present mechanism for the LIKE-to-index
optimization requires the LIKE pattern to be a pure, unadulterated constant.
regards, tom lane