Changeset 4763 for trunk/postgis/sqlmm.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/sqlmm.sql.in.c (modified) (1 diff)

trunk/postgis/sqlmm.sql.in.c

@@ -149 +149 @@
 -- ST_Y(geometry) - already defined.
 
--- PostGIS equivalent function: ~= 
+-- Availability: 1.5.0
+CREATE OR REPLACE FUNCTION _ST_OrderingEquals(geometry, geometry)
+        RETURNS boolean
+        AS 'MODULE_PATHNAME', 'LWGEOM_same'
+        LANGUAGE 'C' IMMUTABLE STRICT
+        COST 100;
+
+-- Availability: 1.3.0
 CREATE OR REPLACE FUNCTION ST_OrderingEquals(geometry, geometry)
         RETURNS boolean
         AS $$ 
-        SELECT $1 && $2 AND $1 ~= $2
+        SELECT $1 ~= $2 AND _ST_OrderingEquals($1, $2)
         $$      
         LANGUAGE 'SQL' IMMUTABLE STRICT;