summaryrefslogtreecommitdiff
path: root/contrib/fuzzystrmatch
Commit message (Collapse)AuthorAgeFilesLines
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* Fix some copyright notices that weren't updated. Improve copyright toolTom Lane2003-08-043-3/+3
| | | | so it won't miss 'em again.
* pgindent run.Bruce Momjian2003-08-041-3/+3
|
* Error message editing in contrib (mostly by Joe Conway --- thanks Joe!)Tom Lane2003-07-241-5/+24
|
* Jim C. Nasby wrote:Bruce Momjian2003-06-243-7/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > 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
* Backend support for autocommit removed, per recent discussions. TheTom Lane2003-05-141-2/+0
| | | | | | only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
* This patch fixes a bunch of spelling mistakes in comments throughout theTom Lane2003-03-101-3/+3
| | | | | | PostgreSQL source code. Neil Conway
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-181-11/+17
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* The attached adds GRANTs to PUBLIC for contrib/fuzzystringmatch.Tom Lane2002-09-141-0/+5
| | | | Joe Conway
* Be careful to include postgres.h *before* any system headers, to ensureTom Lane2002-09-051-3/+2
| | | | | | that the right flavors of largefile-related definitions are seen. Most of these changes are probably unnecessary, but better safe than sorry.
* Make sure that all <ctype.h> routines are called with unsigned charTom Lane2001-12-302-10/+11
| | | | | values; it's not portable to call them with signed chars. I recall doing this for the last release, but a few more uncasted calls have snuck in.
* New pgindent run with fixes suggested by Tom. Patch manually reviewed,Bruce Momjian2001-11-051-1/+1
| | | | initdb/regression tests pass.
* Add trailing semicolon for Joe ConwayBruce Momjian2001-10-291-2/+2
|
* pgindent run on all C files. Java run to follow. initdb/regressionBruce Momjian2001-10-252-262/+293
| | | | tests pass.
* Add do { ... } while (0) to more bad macros.Bruce Momjian2001-10-251-2/+2
|
* To fix the perpetually broken makefiles in the contrib tree, I havePeter Eisentraut2001-09-061-36/+6
| | | | | | written a generic framework of rules that the contrib makefiles can use instead of writing their own each time. You only need to set a few variables and off you go.
* Sorry - I should have gotten to this sooner. Here's a patch which you shouldBruce Momjian2001-08-075-10/+165
| | | | | | | | | be able to apply against what you just committed. It rolls soundex into fuzzystrmatch. Remove soundex/metaphone and merge into fuzzystrmatch. Joe Conway
* Per this discussion, here's a patch to implement both levenshtein() andBruce Momjian2001-08-075-0/+959
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