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: | Raw Message | Whole Thread | 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? |