]> granicus.if.org Git - postgresql/commit
Per this discussion, here's a patch to implement both levenshtein() and
authorBruce Momjian <bruce@momjian.us>
Tue, 7 Aug 2001 16:47:43 +0000 (16:47 +0000)
committerBruce Momjian <bruce@momjian.us>
Tue, 7 Aug 2001 16:47:43 +0000 (16:47 +0000)
commitd8783c512e3c90c705ce61a225df39f962db9ab3
tree2d086880b44cdb213de4c9f7553a689c5f7a5e31
parent0bc291e03cbd0b46414288ea5c94ac5b5a8769fa
Per this discussion, here's a patch to implement both levenshtein() and
metaphone() in a contrib. There seem to be a fair number of different
approaches to both of these algorithms. I used the simplest case for
levenshtein which has a cost  of 1 for any character insertion, deletion, or
substitution. For metaphone, I adapted the same code from CPAN that the PHP
folks did.

A couple of questions:
1. Does it make sense to fold the soundex contrib together with this one?

2. I was debating trying to add multibyte support to levenshtein (it would
make no sense at all for metaphone), but a quick search through the contrib
directory found no hits on the word MULTIBYTE. Should worry about adding
multibyte support to levenshtein()?

Joe Conway
contrib/README
contrib/fuzzystrmatch/Makefile [new file with mode: 0644]
contrib/fuzzystrmatch/README.fuzzystrmatch [new file with mode: 0644]
contrib/fuzzystrmatch/fuzzystrmatch.c [new file with mode: 0644]
contrib/fuzzystrmatch/fuzzystrmatch.h [new file with mode: 0644]
contrib/fuzzystrmatch/fuzzystrmatch.sql.in [new file with mode: 0644]