Jeff, I'm not seeing that limitation.
On Thu, Dec 18, 2014 at 10:33 AM, Jeff Janes <jeff.ja...@gmail.com> wrote: > > On Thu, Dec 18, 2014 at 10:00 AM, Giuseppe Broccolo < > giuseppe.brocc...@2ndquadrant.it> wrote: >> >> I'm not sure about the '%' operator, but I'm sure that the GIST index >> will never be used in the >> >> SELECT * FROM users WHERE lower(name) LIKE '%john%'; >> >> query; it is used for left or right anchored search, such as 'john%' or >> '%john'. >> > > The point of the gist_trgm_ops operator is specifically to overcome that > limitation. > > It is pretty awesome. > > Cheers, > > Jeff >> >>