1
SET search_path = public;
5
create function set_limit(float4)
8
LANGUAGE 'C' with (isstrict,iscachable);
10
create function show_limit()
13
LANGUAGE 'C' with (isstrict,iscachable);
15
create function show_trgm(text)
18
LANGUAGE 'C' with (isstrict,iscachable);
20
create function similarity(text,text)
23
LANGUAGE 'C' with (isstrict,iscachable);
25
create function similarity_op(text,text)
28
LANGUAGE 'C' with (isstrict,iscachable);
33
PROCEDURE = similarity_op,
40
CREATE FUNCTION gtrgm_in(cstring)
43
LANGUAGE 'C' with (isstrict);
45
CREATE FUNCTION gtrgm_out(gtrgm)
48
LANGUAGE 'C' with (isstrict);
57
CREATE FUNCTION gtrgm_consistent(gtrgm,internal,int4)
62
CREATE FUNCTION gtrgm_compress(internal)
67
CREATE FUNCTION gtrgm_decompress(internal)
72
CREATE FUNCTION gtrgm_penalty(internal,internal,internal)
75
LANGUAGE 'C' with (isstrict);
77
CREATE FUNCTION gtrgm_picksplit(internal, internal)
82
CREATE FUNCTION gtrgm_union(bytea, internal)
87
CREATE FUNCTION gtrgm_same(gtrgm, gtrgm, internal)
92
-- create the operator class
93
CREATE OPERATOR CLASS gist_trgm_ops
94
FOR TYPE text USING gist
96
OPERATOR 1 % (text, text),
97
FUNCTION 1 gtrgm_consistent (gtrgm, internal, int4),
98
FUNCTION 2 gtrgm_union (bytea, internal),
99
FUNCTION 3 gtrgm_compress (internal),
100
FUNCTION 4 gtrgm_decompress (internal),
101
FUNCTION 5 gtrgm_penalty (internal, internal, internal),
102
FUNCTION 6 gtrgm_picksplit (internal, internal),
103
FUNCTION 7 gtrgm_same (gtrgm, gtrgm, internal),