Re: Full Text Index Scanning
| От | Matt Warner |
|---|---|
| Тема | Re: Full Text Index Scanning |
| Дата | |
| Msg-id | AANLkTimYv-QjAZXLMdt0v-S-TUVB0wXK5FEtKdhrF5J9@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Full Text Index Scanning (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | 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@sss.pgh.pa.us> wrote:
Matt Warner <matt@warnertechnology.com> writes:> If I understand this, it looks like this approach allows me to match theYeah, probably. You might consider using contrib/pg_trgm instead if
> beginnings and endings of words, but not the middle sections.
you need arbitrary substrings.
regards, tom lane
В списке pgsql-general по дате отправления: