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
>>
>>

Reply via email to