modifiers to encourage use of indices

diff --git a/sql/functions.sql b/sql/functions.sql
index c47f491cd1c6cbd8fa1b3f0bfdf836a1198b039b..a68a90b3c151af7da22b4df87734cf73cee8c611 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1573,7 +1573,7 @@ BEGIN
           make_standard_name(name->'name') = make_standard_name(NEW.name->'name')
           AND placex.rank_search = NEW.rank_search
           AND placex.place_id != NEW.place_id
           make_standard_name(name->'name') = make_standard_name(NEW.name->'name')
           AND placex.rank_search = NEW.rank_search
           AND placex.place_id != NEW.place_id

-          AND osm_type = 'N'
+          AND placex.osm_type = 'N' AND placex.rank_search < 26

           AND st_contains(NEW.geometry, placex.geometry)
         LOOP
 
           AND st_contains(NEW.geometry, placex.geometry)
         LOOP
 


@@ -2782,4 +2782,4 @@ EXCEPTION
   WHEN others THEN return null;
 END;
 $$
   WHEN others THEN return null;
 END;
 $$

-LANGUAGE plpgsql;
+LANGUAGE plpgsql IMMUTABLE;