Changeset 4763 for trunk/postgis/postgis.sql.in.c

Timestamp:

11/06/09 17:31:07 (3 years ago)

Author:

pramsey

Message:

Make ~= be a bounding box only operator and upgrade ST_Equals() and ST_OrderingEquals() to match the new behavior. Update regression tests to match new behavior. (#282) See also #289 for an odd quirk discovered while updating regression tests.

Files:

• trunk/postgis/postgis.sql.in.c (modified) (3 diffs)

trunk/postgis/postgis.sql.in.c

@@ -645 +645 @@
         LANGUAGE 'C' IMMUTABLE STRICT;
 
-CREATE OR REPLACE FUNCTION geometry_same(geometry, geometry)
+CREATE OR REPLACE FUNCTION geometry_samebox(geometry, geometry)
         RETURNS bool
-        AS 'MODULE_PATHNAME', 'LWGEOM_same'
+        AS 'MODULE_PATHNAME', 'LWGEOM_samebox'
         LANGUAGE 'C' IMMUTABLE STRICT;
 
@@ -706 +706 @@
 
 CREATE OPERATOR ~= (
-        LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_same,
+        LEFTARG = geometry, RIGHTARG = geometry, PROCEDURE = geometry_samebox,
         COMMUTATOR = '~=',
         RESTRICT = eqsel, JOIN = eqjoinsel
@@ -4218 +4218 @@
         LANGUAGE 'C' IMMUTABLE STRICT;
 
--- PostGIS equivalent function: Equals(geometry,geometry)
-CREATE OR REPLACE FUNCTION ST_Equals(geometry,geometry)
+-- Availability: 1.5.0
+CREATE OR REPLACE FUNCTION _ST_Equals(geometry,geometry)
         RETURNS boolean
         AS 'MODULE_PATHNAME','geomequals'
         LANGUAGE 'C' IMMUTABLE STRICT
         COST 100;
+
+-- Availability: 1.2.1
+CREATE OR REPLACE FUNCTION ST_Equals(geometry,geometry)
+        RETURNS boolean
+        AS 'SELECT $1 ~= $2 AND _ST_Equals($1,$2)'
+        LANGUAGE 'SQL' IMMUTABLE STRICT;