remove ST_Covers check when also testing for ST_Intersects

[nominatim.git] / sql / functions / place_triggers.sql

diff --git a/sql/functions/place_triggers.sql b/sql/functions/place_triggers.sql
index 71f918c544d0d2c21828cd3d149c70b9bd201b2f..b8dd10753c830f4d1c61b74f9a9460d650cc498a 100644 (file)
--- a/sql/functions/place_triggers.sql
+++ b/sql/functions/place_triggers.sql
@@ -162,14 +162,14 @@ BEGIN
       IF st_area(NEW.geometry) < 0.000000001 AND st_area(existinggeometry) < 1 THEN
 
         -- re-index points that have moved in / out of the polygon, could be done as a single query but postgres gets the index usage wrong
       IF st_area(NEW.geometry) < 0.000000001 AND st_area(existinggeometry) < 1 THEN
 
         -- re-index points that have moved in / out of the polygon, could be done as a single query but postgres gets the index usage wrong

-        update placex set indexed_status = 2 where indexed_status = 0 and 
-            (st_covers(NEW.geometry, placex.geometry) OR ST_Intersects(NEW.geometry, placex.geometry))
-            AND NOT (st_covers(existinggeometry, placex.geometry) OR ST_Intersects(existinggeometry, placex.geometry))
+        update placex set indexed_status = 2 where indexed_status = 0
+            AND ST_Intersects(NEW.geometry, placex.geometry)
+            AND NOT ST_Intersects(existinggeometry, placex.geometry)

             AND rank_search > existingplacex.rank_search AND (rank_search < 28 or name is not null);
 
             AND rank_search > existingplacex.rank_search AND (rank_search < 28 or name is not null);
 

-        update placex set indexed_status = 2 where indexed_status = 0 and 
-            (st_covers(existinggeometry, placex.geometry) OR ST_Intersects(existinggeometry, placex.geometry))
-            AND NOT (st_covers(NEW.geometry, placex.geometry) OR ST_Intersects(NEW.geometry, placex.geometry))
+        update placex set indexed_status = 2 where indexed_status = 0
+            AND ST_Intersects(existinggeometry, placex.geometry)
+            AND NOT ST_Intersects(NEW.geometry, placex.geometry)

             AND rank_search > existingplacex.rank_search AND (rank_search < 28 or name is not null);
 
       END IF;
             AND rank_search > existingplacex.rank_search AND (rank_search < 28 or name is not null);
 
       END IF;