Postgres Pro
Downloads
Home   >   mailing lists

Re: Full Text Index Scanning - Mailing list pgsql-general

From Matt Warner
Subject Re: Full Text Index Scanning
Date
Msg-id AANLkTimYv-QjAZXLMdt0v-S-TUVB0wXK5FEtKdhrF5J9@mail.gmail.com
Whole thread Raw
In response to Re: Full Text Index Scanning  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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@sss.pgh.pa.us> wrote:
Matt Warner <matt@warnertechnology.com> 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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Adding more space, and a vacuum question.
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: One last Ruby question for tonight - Regarding UUID type