Dan Sugalski <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
