From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fuzzy text search |
Date: | 2005-11-14 16:15:15 |
Message-ID: | dlad4v$baq$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 14.11.2005 16:46, jennyw wrote:
> We've heard that PostgreSQL can do fuzzy search, but haven't had much
> luck. I'm brand new to PostgreSQL, so this might be completely obvious
> for an experienced user.
> Are there any how-tos on fuzzy text searching? Someone said to try using
> tsearch2, but it seems that it does full-text searching, but not fuzzy
> search. Ideally, we'd like to use that w/ a fuzzy search option. In
> particular, if someone searches for "imat" we want to return results
> including "immaterial" and "imaterial" (so misspellings plus partial
> match).
tsearch2 + pg_trgm might be what your are looking for, both can be found
in the contrib directory.
--
Regards,
Hannes Dorbath
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2005-11-14 16:17:48 | Re: Fuzzy text search |
Previous Message | Martijn van Oosterhout | 2005-11-14 16:09:35 | Re: Fuzzy text search |