| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Joe Conway" <joseph(dot)conway(at)home(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | "Josh Berkus" <josh(at)agliodbs(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Fuzzy matching? |
| Date: | 2001-07-31 18:15:36 |
| Message-ID: | web-94485@davinci.ethosmedia.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches pgsql-sql |
Joe,
> In any case, metaphone is reportedly more accurate (at least for
> English
> words) than soundex, and levenshtein offers an entirely different and
> interesting approach. Any interest in having all three of these in
> the
> backend?
I'm quite interested, myself. How difficult is it for somebody that
doesn't program C to attach a function from the Contrib directory? If
it's not very difficult, then I'd recommend putting metaphone in
/contrib, and levenstein in the backend. My reasoning is that
levenstein is useful for all roman alphabets, but metaphone is not so
useful for non-english versions of postgres.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-31 18:48:37 | Re: Fuzzy matching? |
| Previous Message | Bruce Momjian | 2001-07-31 18:11:07 | Re: Fuzzy matching? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-31 18:48:37 | Re: Fuzzy matching? |
| Previous Message | Bruce Momjian | 2001-07-31 18:11:07 | Re: Fuzzy matching? |