From: | Matt Warner <matt(at)warnertechnology(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Full Text Index Scanning |
Date: | 2011-01-31 02:45:32 |
Message-ID: | AANLkTimYv-QjAZXLMdt0v-S-TUVB0wXK5FEtKdhrF5J9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Matt Warner <matt(at)warnertechnology(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan S. Katz | 2011-01-31 03:02:40 | Re: One last Ruby question for tonight - Regarding UUID type |
Previous Message | Craig Ringer | 2011-01-31 01:49:16 | Re: Adding more space, and a vacuum question. |