summaryrefslogtreecommitdiff
path: root/contrib/fuzzystrmatch
Commit message (Collapse)AuthorAgeFilesLines
* Fix a few places where $Id$ and $Header$ CVS tags had crept into theTom Lane2006-07-161-7/+1
| | | | source tree. They should all be $PostgreSQL$ of course.
* Fix a passel of recently-committed violations of the rule 'thou shaltTom Lane2006-07-141-4/+4
| | | | | have no other gods before c.h'. Also remove some demonstrably redundant #include lines, mostly of <errno.h> which was added to c.h years ago.
* Remove a few baby-C macros in fuzzystrmatch. Add a few missing includes.Bruce Momjian2006-07-102-8/+5
|
* Magic blocks don't do us any good unless we use 'em ... so install oneTom Lane2006-05-301-1/+3
| | | | in every shared library.
* Fix a few places that were checking for the return value of palloc() to beNeil Conway2006-03-191-5/+1
| | | | | non-NULL: palloc() ereports on OOM, so we can safely assume it returns a valid pointer.
* Add CVS tag lines to files that were lacking them.Bruce Momjian2006-03-113-2/+6
|
* Update copyright for 2006. Update scripts.Bruce Momjian2006-03-053-3/+3
|
* Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, inPeter Eisentraut2006-02-271-35/+24
| | | | | particular get rid of single quotes around language names and old WITH () construct.
* contrib uninstall scriptsPeter Eisentraut2006-02-272-1/+18
| | | | by David Fetter
* Standard pgindent run for 8.1.Bruce Momjian2005-10-152-73/+71
|
* One of the web pages mentioned in dmetaphone.c has moved. Also fixBruce Momjian2005-09-302-7/+7
| | | | | | | | | | a few typos in comments. The dictionaries I checked list "altho" as a variant of "although," but I didn't find any other instances of the former in the source tree so I changed it. Michael Fuhr
* PGXS should be set with := not =, as specified in the documentation,Tom Lane2005-09-271-2/+2
| | | | to avoid useless multiple executions of pg_config.
* The attached patch implements the soundex difference function whichNeil Conway2005-01-265-14/+56
| | | | | | 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 theyTom Lane2005-01-011-1/+1
| | | | | should have been caught by the src/tools/copyright script ... why weren't they?
* Update copyrights that were missed.Bruce Momjian2005-01-012-2/+2
|
* Adjust comments previously moved to column 1 by pgident.Bruce Momjian2004-10-071-3/+3
|
* Pgindent run for 8.0.Bruce Momjian2004-08-291-251/+267
|
* Update copyright to 2004.Bruce Momjian2004-08-293-3/+3
|
* > Please find enclose a submission to fix these problems.Bruce Momjian2004-08-201-5/+9
| | | | | | | | | | | | | | | | | | | | | | > > The patch adds missing the "libpgport.a" file to the installation under > "install-all-headers". It is needed by some contribs. I install the > library in "pkglibdir", but I was wondering whether it should be "libdir"? > I was wondering also whether it would make sense to have a "libpgport.so"? > > It fixes various macros which are used by contrib makefiles, especially > libpq_*dir and LDFLAGS when used under PGXS. It seems to me that they are > needed to > > It adds the ability to test and use PGXS with contribs, with "make > USE_PGXS=1". Without the macro, this is exactly as before, there should be > no difference, esp. wrt the vpath feature that seemed broken by previous > submission. So it should not harm anybody, and it is useful at least to me. > > It fixes some inconsistencies in various contrib makefiles > (useless override, ":=" instead of "="). Fabien COELHO
* I notice that contrib/fuzzystrmatch/dmetaphone.c doesn't compile cleanlyBruce Momjian2004-08-201-19/+25
| | | | | | | | as it stands - it mixes declarations in code, C++-style. The attached patch shifts declarations to the tops of functions and enables this file to compile cleanly as C. Richard Poole
* Add double metaphone code from Andrew Dunstan. Also change metaphone so thatJoe Conway2004-07-016-7/+1489
| | | | | | 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.
* $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