1
-- Adjust this setting to control where the objects get created.
2
SET search_path = public;
11
-- define the GiST support methods
12
CREATE FUNCTION gbox_consistent(internal,box,int4)
17
CREATE FUNCTION gbox_compress(internal)
22
CREATE FUNCTION rtree_decompress(internal)
27
CREATE FUNCTION gbox_penalty(internal,internal,internal)
30
LANGUAGE 'C' with (isstrict);
32
CREATE FUNCTION gbox_picksplit(internal, internal)
37
CREATE FUNCTION gbox_union(internal, internal)
42
CREATE FUNCTION gbox_same(box, box, internal)
47
-- create the operator class
48
CREATE OPERATOR CLASS gist_box_ops
49
DEFAULT FOR TYPE box USING gist
59
FUNCTION 1 gbox_consistent (internal, box, int4),
60
FUNCTION 2 gbox_union (internal, internal),
61
FUNCTION 3 gbox_compress (internal),
62
FUNCTION 4 rtree_decompress (internal),
63
FUNCTION 5 gbox_penalty (internal, internal, internal),
64
FUNCTION 6 gbox_picksplit (internal, internal),
65
FUNCTION 7 gbox_same (box, box, internal);
75
-- define the GiST support methods
76
CREATE FUNCTION gpoly_consistent(internal,polygon,int4)
81
CREATE FUNCTION gpoly_compress(internal)
86
-- create the operator class
87
CREATE OPERATOR CLASS gist_poly_ops
88
DEFAULT FOR TYPE polygon USING gist
90
OPERATOR 1 << RECHECK,
91
OPERATOR 2 &< RECHECK,
92
OPERATOR 3 && RECHECK,
93
OPERATOR 4 &> RECHECK,
94
OPERATOR 5 >> RECHECK,
95
OPERATOR 6 ~= RECHECK,
98
FUNCTION 1 gpoly_consistent (internal, polygon, int4),
99
FUNCTION 2 gbox_union (internal, internal),
100
FUNCTION 3 gpoly_compress (internal),
101
FUNCTION 4 rtree_decompress (internal),
102
FUNCTION 5 gbox_penalty (internal, internal, internal),
103
FUNCTION 6 gbox_picksplit (internal, internal),
104
FUNCTION 7 gbox_same (box, box, internal),