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

Re: any solution for full text search in Postgres for partial words

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: "Liu, Mingyi" <Mingyi(dot)Liu(at)gpc-biotech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: any solution for full text search in Postgres for partial words
Date: 2004-08-25 16:24:46
Message-ID: 20040825162446.GB18252@dcc.uchile.cl (view raw or flat)
Thread:
Lists: 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!


In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2004-08-25 16:26:07
Subject: Re: copy a database
Previous:From: Devrim GUNDUZDate: 2004-08-25 16:10:58
Subject: Re: Gentoo for production DB server?

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