summaryrefslogtreecommitdiff
path: root/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
diff options
context:
space:
mode:
authorBruce Momjian2001-08-07 18:16:01 +0000
committerBruce Momjian2001-08-07 18:16:01 +0000
commitcdd02cdf00f020292cdcc8dafa5475e0149c34a6 (patch)
tree317c5c67dbecac152c6c67766ac86d3f5c8e9536 /contrib/fuzzystrmatch/fuzzystrmatch.sql.in
parentfb5b85a8f2663883f1e3287680dbe0db54e1b617 (diff)
Sorry - I should have gotten to this sooner. Here's a patch which you should
be able to apply against what you just committed. It rolls soundex into fuzzystrmatch. Remove soundex/metaphone and merge into fuzzystrmatch. Joe Conway
Diffstat (limited to 'contrib/fuzzystrmatch/fuzzystrmatch.sql.in')
-rw-r--r--contrib/fuzzystrmatch/fuzzystrmatch.sql.in6
1 files changed, 6 insertions, 0 deletions
diff --git a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
index 4125b75d144..b02f1b28ebc 100644
--- a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
+++ b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
@@ -3,3 +3,9 @@ CREATE FUNCTION levenshtein (text,text) RETURNS int
CREATE FUNCTION metaphone (text,int) RETURNS text
AS 'MODULE_PATHNAME','metaphone' LANGUAGE 'c' with (iscachable, isstrict);
+
+CREATE FUNCTION soundex(text) RETURNS text
+ AS 'MODULE_PATHNAME', 'soundex' LANGUAGE 'c' with (iscachable, isstrict);
+
+CREATE FUNCTION text_soundex(text) RETURNS text
+ AS 'MODULE_PATHNAME', 'soundex' LANGUAGE 'c';