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 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Adding more space, and a vacuum question.
Следующее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: One last Ruby question for tonight - Regarding UUID type