| rev |
line source |
|
jbe@64
|
1 DROP OPERATOR CLASS epoint_ops USING gist;
|
|
jbe@64
|
2 DROP OPERATOR CLASS ecluster_ops USING gist;
|
|
jbe@64
|
3
|
|
jbe@64
|
4 DROP OPERATOR <@ (epoint, ecluster);
|
|
jbe@64
|
5
|
|
jbe@64
|
6 CREATE OPERATOR <@ (
|
|
jbe@64
|
7 leftarg = epoint,
|
|
jbe@64
|
8 rightarg = ecluster,
|
|
jbe@64
|
9 procedure = epoint_ecluster_overlap_proc,
|
|
jbe@64
|
10 commutator = @>,
|
|
jbe@64
|
11 restrict = areasel,
|
|
jbe@64
|
12 join = areajoinsel
|
|
jbe@64
|
13 );
|
|
jbe@64
|
14
|
|
jbe@64
|
15 CREATE OPERATOR CLASS epoint_ops
|
|
jbe@64
|
16 DEFAULT FOR TYPE epoint USING gist AS
|
|
jbe@64
|
17 OPERATOR 11 = ,
|
|
jbe@64
|
18 OPERATOR 22 && (epoint, ebox),
|
|
jbe@64
|
19 OPERATOR 222 <@ (epoint, ebox),
|
|
jbe@64
|
20 OPERATOR 23 && (epoint, ecircle),
|
|
jbe@64
|
21 OPERATOR 24 && (epoint, ecluster),
|
|
jbe@64
|
22 OPERATOR 124 &&+ (epoint, ecluster),
|
|
jbe@64
|
23 OPERATOR 224 <@ (epoint, ecluster),
|
|
jbe@64
|
24 OPERATOR 31 <-> (epoint, epoint) FOR ORDER BY float_ops,
|
|
jbe@64
|
25 OPERATOR 32 <-> (epoint, ebox) FOR ORDER BY float_ops,
|
|
jbe@64
|
26 OPERATOR 33 <-> (epoint, ecircle) FOR ORDER BY float_ops,
|
|
jbe@64
|
27 OPERATOR 34 <-> (epoint, ecluster) FOR ORDER BY float_ops,
|
|
jbe@64
|
28 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
|
|
jbe@64
|
29 FUNCTION 2 pgl_gist_union(internal, internal),
|
|
jbe@64
|
30 FUNCTION 3 pgl_gist_compress_epoint(internal),
|
|
jbe@64
|
31 FUNCTION 4 pgl_gist_decompress(internal),
|
|
jbe@64
|
32 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
|
|
jbe@64
|
33 FUNCTION 6 pgl_gist_picksplit(internal, internal),
|
|
jbe@64
|
34 FUNCTION 7 pgl_gist_same(internal, internal, internal),
|
|
jbe@64
|
35 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
|
|
jbe@64
|
36 STORAGE ekey_point;
|
|
jbe@64
|
37
|
|
jbe@64
|
38 CREATE OPERATOR CLASS ecluster_ops
|
|
jbe@64
|
39 DEFAULT FOR TYPE ecluster USING gist AS
|
|
jbe@64
|
40 OPERATOR 21 && (ecluster, epoint),
|
|
jbe@64
|
41 OPERATOR 121 &&+ (ecluster, epoint),
|
|
jbe@64
|
42 OPERATOR 221 @> (ecluster, epoint),
|
|
jbe@64
|
43 OPERATOR 22 && (ecluster, ebox),
|
|
jbe@64
|
44 OPERATOR 122 &&+ (ecluster, ebox),
|
|
jbe@64
|
45 OPERATOR 222 @> (ecluster, ebox),
|
|
jbe@64
|
46 OPERATOR 322 <@ (ecluster, ebox),
|
|
jbe@64
|
47 OPERATOR 23 && (ecluster, ecircle),
|
|
jbe@64
|
48 OPERATOR 123 &&+ (ecluster, ecircle),
|
|
jbe@64
|
49 OPERATOR 24 && (ecluster, ecluster),
|
|
jbe@64
|
50 OPERATOR 124 &&+ (ecluster, ecluster),
|
|
jbe@64
|
51 OPERATOR 224 @> (ecluster, ecluster),
|
|
jbe@64
|
52 OPERATOR 324 <@ (ecluster, ecluster),
|
|
jbe@64
|
53 OPERATOR 31 <-> (ecluster, epoint) FOR ORDER BY float_ops,
|
|
jbe@64
|
54 OPERATOR 32 <-> (ecluster, ebox) FOR ORDER BY float_ops,
|
|
jbe@64
|
55 OPERATOR 33 <-> (ecluster, ecircle) FOR ORDER BY float_ops,
|
|
jbe@64
|
56 OPERATOR 34 <-> (ecluster, ecluster) FOR ORDER BY float_ops,
|
|
jbe@64
|
57 OPERATOR 131 <=> (ecluster, epoint_with_sample_count) FOR ORDER BY float_ops,
|
|
jbe@64
|
58 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
|
|
jbe@64
|
59 FUNCTION 2 pgl_gist_union(internal, internal),
|
|
jbe@64
|
60 FUNCTION 3 pgl_gist_compress_ecluster(internal),
|
|
jbe@64
|
61 FUNCTION 4 pgl_gist_decompress(internal),
|
|
jbe@64
|
62 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
|
|
jbe@64
|
63 FUNCTION 6 pgl_gist_picksplit(internal, internal),
|
|
jbe@64
|
64 FUNCTION 7 pgl_gist_same(internal, internal, internal),
|
|
jbe@64
|
65 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
|
|
jbe@64
|
66 STORAGE ekey_area;
|
|
jbe@64
|
67
|