Re: Full Text Index Scanning

[Matt Warner <matt@xxxxxxxxxxxxxxxxxxxx>]

Thanks. pg_trgm looks interesting, but after installing the pg_trgm.sql, I get error messages when following the documentation.

sggeeorg=> create index test_idx on test using gist(columnname gist_trgm_ops);

ERROR:  operator class "gist_trgm_ops" does not exist for access method "gist"

STATEMENT:  create index test_idx on test using gist(columnname gist_trgm_ops);

ERROR:  operator class "gist_trgm_ops" does not exist for access method "gist"

On Sun, Jan 30, 2011 at 10:36 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Matt Warner <matt@xxxxxxxxxxxxxxxxxxxx> writes:

> If I understand this, it looks like this approach allows me to match the
> beginnings and endings of words, but not the middle sections.

Yeah, probably.  You might consider using contrib/pg_trgm instead if
you need arbitrary substrings.

                       regards, tom lane