From: | Christopher Sawtell <csawtell(at)paradise(dot)net(dot)nz> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Fuzzy matching? |
Date: | 2001-07-31 21:31:51 |
Message-ID: | 20010731213157.E6A741F9F1B@deborah.paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches pgsql-sql |
On Wed, 01 Aug 2001 05:44, Tom Lane wrote:
> "Josh Berkus" <josh(at)agliodbs(dot)com> writes:
> > For many of my programs, it would be extremely useful to have some form
> > of "fuzzy matching" for VARCHAR fields. There are two kinds of fuzzy
> > matching for words that I know of:
> >
> > 1. Phonetic matching, which would be nice but will have to wait for
> > someone's $100,000 project;
>
> Uh, have you looked at contrib/soundex? The Soundex code is kinda
> specialized but might be just what you want...
Be aware that Soundex simply does not work at all well on names of Pacific
origin. Samoan in particular is a total no no.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-07-31 21:51:45 | Re: Revised Patch to allow multiple table locks in "Unison" |
Previous Message | Josh Berkus | 2001-07-31 20:53:37 | Re: Fuzzy matching? |
From | Date | Subject | |
---|---|---|---|
Next Message | Timothy H. Keitt | 2001-08-01 02:27:17 | Re: Fuzzy matching? |
Previous Message | Josh Berkus | 2001-07-31 20:53:37 | Re: Fuzzy matching? |