Re: accessing the words in a full text index

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: "Massa\, Harald Armin" <chef(at)ghum(dot)de>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: accessing the words in a full text index
Date: 2010-03-07 14:21:31
Message-ID: m2iq986wlw.fsf@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Massa, Harald Armin" <chef(at)ghum(dot)de> writes:

> I want to provide a "suggest word as you type" feature in an application (like google suggest). 
> All the documents are - of course - stored within a PostgreSQL
> database, within TEXT columns.

See pg_trgm.

http://www.postgresql.org/docs/8.4/static/pgtrgm.html

Regards,
--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-07 15:34:31 Re: timestamp literal out of line
Previous Message Martijn van Oosterhout 2010-03-07 12:32:29 timestamp literal out of line