contrib/fuzzystrmatch/fuzzystrmatch.sql.in

   1 /* $PostgreSQL$ */
   2
   3 -- Adjust this setting to control where the objects get created.
   4 SET search_path = public;
   5
   6 CREATE OR REPLACE FUNCTION levenshtein (text,text) RETURNS int
   7 AS 'MODULE_PATHNAME','levenshtein'
   8 LANGUAGE C IMMUTABLE STRICT;
   9
  10 CREATE OR REPLACE FUNCTION levenshtein (text,text,int,int,int) RETURNS int
  11 AS 'MODULE_PATHNAME','levenshtein_with_costs'
  12 LANGUAGE C IMMUTABLE STRICT;
  13
  14 CREATE OR REPLACE FUNCTION metaphone (text,int) RETURNS text
  15 AS 'MODULE_PATHNAME','metaphone'
  16 LANGUAGE C IMMUTABLE STRICT;
  17
  18 CREATE OR REPLACE FUNCTION soundex(text) RETURNS text
  19 AS 'MODULE_PATHNAME', 'soundex'
  20 LANGUAGE C IMMUTABLE STRICT;
  21
  22 CREATE OR REPLACE FUNCTION text_soundex(text) RETURNS text
  23 AS 'MODULE_PATHNAME', 'soundex'
  24 LANGUAGE C IMMUTABLE STRICT;
  25
  26 CREATE OR REPLACE FUNCTION difference(text,text) RETURNS int
  27 AS 'MODULE_PATHNAME', 'difference'
  28 LANGUAGE C IMMUTABLE STRICT;
  29
  30 CREATE OR REPLACE FUNCTION dmetaphone (text) RETURNS text
  31 AS 'MODULE_PATHNAME', 'dmetaphone'
  32 LANGUAGE C IMMUTABLE STRICT;
  33
  34 CREATE OR REPLACE FUNCTION dmetaphone_alt (text) RETURNS text
  35 AS 'MODULE_PATHNAME', 'dmetaphone_alt'
  36 LANGUAGE C IMMUTABLE STRICT;