Postgres Pro
Downloads
Home   >   mailing lists

Prefix search, word completion, full text search - Mailing list pgsql-general

From Vincent Bernat
Subject Prefix search, word completion, full text search
Date
Msg-id m3r6h5jnou.fsf@neo.luffy.cx
Whole thread Raw
Responses Re: Prefix search, word completion, full text search
List pgsql-general
Tree view 
Hi !

I am  playing with the new full  text search in PostgreSQL  8.3. I would
like to search for prefixes to  allow to complete words. For example, if
I have  the lexemes 'foo', 'foobar' and  'bar', I would like  to get all
the words whose prefix is 'foo', i.e 'foo' and 'foobar'.

GIST or  GIN (I don't remember)  should allow to search  for prefix. How
can I query them?

Thanks.
--
BOFH excuse #348:
We're on Token Ring, and it looks like the token got loose.

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: functional dependency tool
Next
From: "Anthony B. Colson"
Date:
Subject: Re: Red Hat 9