Re: Question about trigram GIST index

[Robert DiFalco <robert.difalco@xxxxxxxxx>]

Jeff, I'm not seeing that limitation.

On Thu, Dec 18, 2014 at 10:33 AM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote:

On Thu, Dec 18, 2014 at 10:00 AM, Giuseppe Broccolo <giuseppe.broccolo@xxxxxxxxxxxxxx> 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