contrib/fuzzystrmatch/fuzzystrmatch.sql.in


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

CREATE FUNCTION levenshtein (text,text) RETURNS int
  AS 'MODULE_PATHNAME','levenshtein' LANGUAGE 'c' with (iscachable, isstrict);

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';

GRANT EXECUTE ON FUNCTION levenshtein (text,text) TO PUBLIC;
GRANT EXECUTE ON FUNCTION metaphone (text,int) TO PUBLIC;
GRANT EXECUTE ON FUNCTION soundex(text) TO PUBLIC;
GRANT EXECUTE ON FUNCTION text_soundex(text) TO PUBLIC;