Re: any solution for full text search in Postgres for partial words - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: any solution for full text search in Postgres for partial words
Date
Msg-id 20040825162446.GB18252@dcc.uchile.cl
Whole thread Raw
In response to any solution for full text search in Postgres for partial words  ("Liu, Mingyi" <Mingyi.Liu@gpc-biotech.com>)
List pgsql-general
On Wed, Aug 25, 2004 at 11:14:36AM -0400, Liu, Mingyi wrote:

> 1. Is there existing open-source FTI for postgres that allows partial words search?

I think a trigram-based solution could help you here.  In 8.0beta there
is a contrib/pg_trgm module that implements such a thing.  It isn't
present on previous versions of Postgres though.

See
http://www.sai.msu.su/~megera/oddmuse/index.cgi/ReadmeTrgm

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: copy a database
Next
From: Thomas Hallgren
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions