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 <t...@sss.pgh.pa.us> wrote: > Matt Warner <m...@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 >