codekingpro/portable-devtools

1/* contrib/fuzzystrmatch/fuzzystrmatch--1.1.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION fuzzystrmatch" to load this file. \quit5 6CREATE FUNCTION levenshtein (text,text) RETURNS int7AS 'MODULE_PATHNAME','levenshtein'8LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;9 10CREATE FUNCTION levenshtein (text,text,int,int,int) RETURNS int11AS 'MODULE_PATHNAME','levenshtein_with_costs'12LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;13 14CREATE FUNCTION levenshtein_less_equal (text,text,int) RETURNS int15AS 'MODULE_PATHNAME','levenshtein_less_equal'16LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;17 18CREATE FUNCTION levenshtein_less_equal (text,text,int,int,int,int) RETURNS int19AS 'MODULE_PATHNAME','levenshtein_less_equal_with_costs'20LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;21 22CREATE FUNCTION metaphone (text,int) RETURNS text23AS 'MODULE_PATHNAME','metaphone'24LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;25 26CREATE FUNCTION soundex(text) RETURNS text27AS 'MODULE_PATHNAME', 'soundex'28LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;29 30CREATE FUNCTION text_soundex(text) RETURNS text31AS 'MODULE_PATHNAME', 'soundex'32LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;33 34CREATE FUNCTION difference(text,text) RETURNS int35AS 'MODULE_PATHNAME', 'difference'36LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;37 38CREATE FUNCTION dmetaphone (text) RETURNS text39AS 'MODULE_PATHNAME', 'dmetaphone'40LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;41 42CREATE FUNCTION dmetaphone_alt (text) RETURNS text43AS 'MODULE_PATHNAME', 'dmetaphone_alt'44LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;45