On Feb 13, 2012, at 6:57 PM, David Nicol wrote: > did you find > > http://stackoverflow.com/questions/1566717/postgresql-like-query-performance-variations > > in your research?
Thanks for that link, but I don't think that applies in my case. I have two exact queries, with a postfix wildcard search. One, I prepare with the search term embedded in the query. The other is prepared with a bind variable and the search term is added during $sth->execute. The first one uses the index. The second does a full-table scan. Strange, but true. -- Puneet Kishor
