| From: | Mike Rylander <mrylander(at)gmail(dot)com> |
|---|---|
| To: | Avishai Weissberg <ovesh1(at)yahoo(dot)com>, PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: general purpose full text indexing |
| Date: | 2005-03-28 19:40:20 |
| Message-ID: | b918cf3d050328114077b7afa6@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 28 Mar 2005 21:06:12 +0200, Avishai Weissberg <ovesh1(at)yahoo(dot)com> wrote:
> Hello,
>
> I am trying to find a suitable FTI component.
>
> I am aware of tsearch2, but as far as I understand it doesn't really suit my
> purposes. I want to be able to run a search on a huge TEXT column, where the the
> column's content is made of words (each 'word' is an email address) seperated by
> white-spaces and commas. The search should also support wild-chars. Lexemes are
> not needed, as the 'words' are not in any language.
>
You may want to look at the pg_tgrm contrib module. It is a simpler
"similarity" matcher.
--
Mike Rylander
mrylander(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guy Rouillier | 2005-03-28 19:43:03 | Re: Debugging deadlocks |
| Previous Message | Thomas F.O'Connell | 2005-03-28 19:30:42 | Re: Linux Filesystem for PG |