Skip site navigation (1) Skip section navigation (2)

Re: Full Text Index Scanning

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 (view raw or flat)
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
>

In response to

pgsql-general by date

Next:From: Jonathan S. KatzDate: 2011-01-31 03:02:40
Subject: Re: One last Ruby question for tonight - Regarding UUID type
Previous:From: Craig RingerDate: 2011-01-31 01:49:16
Subject: Re: Adding more space, and a vacuum question.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group