From 768a8d838eac4f0f1920092f83b89f1867d410b8 Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@keybit.net>
Date: Mon, 8 Mar 2004 12:16:30 +0000
Subject: [PATCH] Added the RECHECK clause for gist_geometry_ops operator class
 operators

git-svn-id: http://svn.osgeo.org/postgis/trunk@477 b70326c6-7e19-0410-871a-916f4a2858ee
---
 postgis.sql.in | 54 +++++++++++++++++++++++++-------------------------
 1 file changed, 27 insertions(+), 27 deletions(-)

diff --git a/postgis.sql.in b/postgis.sql.in
index 5efb5693e..4266708fe 100644
--- a/postgis.sql.in
+++ b/postgis.sql.in
@@ -2865,19 +2865,19 @@ CREATE FUNCTION geometry_size(geometry,internal)
 	LANGUAGE 'C';
 
 --
--- Create opclass index bindings
+-- Create opclass index bindings (PG73)
 --
 
 CREATE OPERATOR CLASS gist_geometry_ops
 	DEFAULT FOR TYPE geometry USING gist AS
-	OPERATOR	1	<< ,
-	OPERATOR	2	&< ,
-	OPERATOR	3	&& ,
-	OPERATOR	4	&> ,
-	OPERATOR	5	>> ,
-	OPERATOR	6	~= ,
-	OPERATOR	7	~ ,
-	OPERATOR	8	@ ,
+	OPERATOR	1	<<	RECHECK,
+	OPERATOR	2	&<	RECHECK,
+	OPERATOR	3	&&	RECHECK,
+	OPERATOR	4	&>	RECHECK,
+	OPERATOR	5	>>	RECHECK,
+	OPERATOR	6	~=	RECHECK,
+	OPERATOR	7	~	RECHECK,
+	OPERATOR	8	@	RECHECK,
 	FUNCTION	1	ggeometry_consistent (internal, geometry, int4),
 	FUNCTION	2	gbox_union (bytea, internal),
 	FUNCTION	3	ggeometry_compress (internal),
@@ -3286,19 +3286,19 @@ CREATE FUNCTION geometry_size(geometry,internal)
 	LANGUAGE 'C';
 
 --
--- Create opclass index bindings
+-- Create opclass index bindings (PG74)
 --
 
 CREATE OPERATOR CLASS gist_geometry_ops
 	DEFAULT FOR TYPE geometry USING gist AS
-	OPERATOR	1	<< ,
-	OPERATOR	2	&< ,
-	OPERATOR	3	&& ,
-	OPERATOR	4	&> ,
-	OPERATOR	5	>> ,
-	OPERATOR	6	~= ,
-	OPERATOR	7	~ ,
-	OPERATOR	8	@ ,
+	OPERATOR	1	<<	RECHECK,
+	OPERATOR	2	&<	RECHECK,
+	OPERATOR	3	&&	RECHECK,
+	OPERATOR	4	&>	RECHECK,
+	OPERATOR	5	>>	RECHECK,
+	OPERATOR	6	~=	RECHECK,
+	OPERATOR	7	~	RECHECK,
+	OPERATOR	8	@	RECHECK,
 	FUNCTION	1	ggeometry_consistent (internal, geometry, int4),
 	FUNCTION	2	gbox_union (bytea, internal),
 	FUNCTION	3	ggeometry_compress (internal),
@@ -3703,19 +3703,19 @@ CREATE FUNCTION geometry_size(geometry,internal)
 	LANGUAGE 'C';
 
 --
--- Create opclass index bindings
+-- Create opclass index bindings (PG75)
 --
 
 CREATE OPERATOR CLASS gist_geometry_ops
 	DEFAULT FOR TYPE geometry USING gist AS
-	OPERATOR	1	<< ,
-	OPERATOR	2	&< ,
-	OPERATOR	3	&& ,
-	OPERATOR	4	&> ,
-	OPERATOR	5	>> ,
-	OPERATOR	6	~= ,
-	OPERATOR	7	~ ,
-	OPERATOR	8	@ ,
+	OPERATOR	1	<<	RECHECK,
+	OPERATOR	2	&<	RECHECK,
+	OPERATOR	3	&&	RECHECK,
+	OPERATOR	4	&>	RECHECK,
+	OPERATOR	5	>>	RECHECK,
+	OPERATOR	6	~=	RECHECK,
+	OPERATOR	7	~	RECHECK,
+	OPERATOR	8	@	RECHECK,
 	FUNCTION	1	ggeometry_consistent (internal, geometry, int4),
 	FUNCTION	2	gbox_union (bytea, internal),
 	FUNCTION	3	ggeometry_compress (internal),
-- 
2.50.1