On Thu, Dec 18, 2014 at 10:00 AM, Giuseppe Broccolo <
giuseppe(dot)broccolo(at)2ndquadrant(dot)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
>
>