delta/postgresql.git/contrib/fuzzystrmatch/README.fuzzystrmatch, branch master

Move most /contrib README files into SGML. Some still need conversion

2007-11-10T23:30:46+00:00

or will never be converted.

Update CVS HEAD for 2007 copyright. Back branches are typically not

2007-01-05T22:20:05+00:00

back-stamped for this.

Update copyright for 2006. Update scripts.

2006-03-05T15:59:11+00:00

The attached patch implements the soundex difference function which

2005-01-26T08:04:04+00:00

compares two strings' soundex values for similarity, from Kris Jurka.
Also mark the text_soundex() function as STRICT, to avoid crashing
on NULL input.

Some more missed copyright notices. Many of these look like they

2005-01-01T20:44:34+00:00

should have been caught by the src/tools/copyright script ... why
weren't they?

Update copyright to 2004.

2004-08-29T04:13:13+00:00

Add double metaphone code from Andrew Dunstan. Also change metaphone so that

2004-07-01T03:25:48+00:00

an empty input string causes an empty output string to be returned, instead of
throwing an ERROR -- per complaint from Aaron Hillegass, and consistent with
double metaphone. Fix examples in README.soundex pointed out by James Robinson.

Fix some copyright notices that weren't updated. Improve copyright tool

2003-08-04T23:59:41+00:00

so it won't miss 'em again.

Jim C. Nasby wrote:

2003-06-24T22:59:46+00:00

> Second argument to metaphone is suposed to set the limit on the
> number of characters to return, but it breaks on some phrases:
>
> usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from
> (select 'Hello world'::varchar AS a) a;
> HLW       | HLWR      | HLWRLT
>
> usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from
> (select 'A A COMEAUX MEMORIAL'::varchar AS a) a;
  > AKM       | AKMKS     | AKMKSMMRL
>
> In every case I've found that does this, the 4th and 5th letters are
> always 'KS'.

Nice catch.

There was a bug in the original metaphone algorithm from CPAN. Patch
attached (while I was at it I updated my email address, changed the
copyright to PGDG, and removed an unnecessary palloc). Here's how it
looks now:

regression=# select metaphone(a,4) from (select 'A A COMEAUX
MEMORIAL'::varchar AS a) a;
   metaphone
-----------
   AKMK
(1 row)

regression=# select metaphone(a,5) from (select 'A A COMEAUX
MEMORIAL'::varchar AS a) a;
   metaphone
-----------
   AKMKS
(1 row)

Joe Conway

Sorry - I should have gotten to this sooner. Here's a patch which you should

2001-08-07T18:16:01+00:00

be able to apply against what you just committed. It rolls soundex into
fuzzystrmatch.

Remove soundex/metaphone and merge into fuzzystrmatch.

Joe Conway