aboutsummaryrefslogtreecommitdiff
path: root/contrib/rtree_gist/rtree_gist.sql.in
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-07-01 19:23:07 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-07-01 19:23:07 +0000
commite6a8eba3f2157bca9871539e6be1ca2399c1371e (patch)
tree11f525dd537fb20c3a4c4750f3b519d36127939f /contrib/rtree_gist/rtree_gist.sql.in
parente7e1694295e3d867f07afedf6505d0e0436cb67e (diff)
downloadpostgresql-e6a8eba3f2157bca9871539e6be1ca2399c1371e.tar.gz
postgresql-e6a8eba3f2157bca9871539e6be1ca2399c1371e.zip
Remove contrib version of rtree_gist --- now in core system.
Diffstat (limited to 'contrib/rtree_gist/rtree_gist.sql.in')
-rw-r--r--contrib/rtree_gist/rtree_gist.sql.in113
1 files changed, 0 insertions, 113 deletions
diff --git a/contrib/rtree_gist/rtree_gist.sql.in b/contrib/rtree_gist/rtree_gist.sql.in
deleted file mode 100644
index e59edcacff0..00000000000
--- a/contrib/rtree_gist/rtree_gist.sql.in
+++ /dev/null
@@ -1,113 +0,0 @@
--- Adjust this setting to control where the objects get created.
-SET search_path = public;
-
---
---
---
--- BOX ops
---
---
---
--- define the GiST support methods
-CREATE FUNCTION gbox_consistent(internal,box,int4)
-RETURNS bool
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
-CREATE FUNCTION gbox_compress(internal)
-RETURNS internal
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
-CREATE FUNCTION rtree_decompress(internal)
-RETURNS internal
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
-CREATE FUNCTION gbox_penalty(internal,internal,internal)
-RETURNS internal
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C' STRICT;
-
-CREATE FUNCTION gbox_picksplit(internal, internal)
-RETURNS internal
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
-CREATE FUNCTION gbox_union(internal, internal)
-RETURNS box
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
-CREATE FUNCTION gbox_same(box, box, internal)
-RETURNS internal
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
--- create the operator class
-CREATE OPERATOR CLASS gist_box_ops
-DEFAULT FOR TYPE box USING gist
-AS
- OPERATOR 1 << ,
- OPERATOR 2 &< ,
- OPERATOR 3 && ,
- OPERATOR 4 &> ,
- OPERATOR 5 >> ,
- OPERATOR 6 ~= ,
- OPERATOR 7 ~ ,
- OPERATOR 8 @ ,
- OPERATOR 9 &<| ,
- OPERATOR 10 <<| ,
- OPERATOR 11 |>> ,
- OPERATOR 12 |&> ,
- FUNCTION 1 gbox_consistent (internal, box, int4),
- FUNCTION 2 gbox_union (internal, internal),
- FUNCTION 3 gbox_compress (internal),
- FUNCTION 4 rtree_decompress (internal),
- FUNCTION 5 gbox_penalty (internal, internal, internal),
- FUNCTION 6 gbox_picksplit (internal, internal),
- FUNCTION 7 gbox_same (box, box, internal);
-
-
---
---
---
--- POLYGON ops
---
---
---
--- define the GiST support methods
-CREATE FUNCTION gpoly_consistent(internal,polygon,int4)
-RETURNS bool
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
-CREATE FUNCTION gpoly_compress(internal)
-RETURNS internal
-AS 'MODULE_PATHNAME'
-LANGUAGE 'C';
-
--- create the operator class
-CREATE OPERATOR CLASS gist_poly_ops
-DEFAULT FOR TYPE polygon USING gist
-AS
- OPERATOR 1 << RECHECK,
- OPERATOR 2 &< RECHECK,
- OPERATOR 3 && RECHECK,
- OPERATOR 4 &> RECHECK,
- OPERATOR 5 >> RECHECK,
- OPERATOR 6 ~= RECHECK,
- OPERATOR 7 ~ RECHECK,
- OPERATOR 8 @ RECHECK,
- OPERATOR 9 &<| RECHECK,
- OPERATOR 10 <<| RECHECK,
- OPERATOR 11 |>> RECHECK,
- OPERATOR 12 |&> RECHECK,
- FUNCTION 1 gpoly_consistent (internal, polygon, int4),
- FUNCTION 2 gbox_union (internal, internal),
- FUNCTION 3 gpoly_compress (internal),
- FUNCTION 4 rtree_decompress (internal),
- FUNCTION 5 gbox_penalty (internal, internal, internal),
- FUNCTION 6 gbox_picksplit (internal, internal),
- FUNCTION 7 gbox_same (box, box, internal),
- STORAGE box;