| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | jennyw <jennyw(at)dangerousideas(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fuzzy text search |
| Date: | 2005-11-14 16:17:48 |
| Message-ID: | 4378B8AC.3060301@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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).
>
Look at contrib/pg_trgm. If you want fulltext search with mispelling correction
then read "Tsearch2 Integration" in contrib/pg_trgm/README.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-11-14 16:29:20 | Re: Outer join with where conditions |
| Previous Message | Hannes Dorbath | 2005-11-14 16:15:15 | Re: Fuzzy text search |