From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 5 May 2012 09:38:26 +0000 (+0200)
Subject: modifiers to encourage use of indices
X-Git-Tag: v2.0.0~74
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/cc43bedd2145d1cfc740b0635df3746b620b4778?ds=sidebyside

modifiers to encourage use of indices
---

diff --git a/sql/functions.sql b/sql/functions.sql
index c47f491c..a68a90b3 100644
--- 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
-          AND osm_type = 'N'
+          AND placex.osm_type = 'N' AND placex.rank_search < 26
           AND st_contains(NEW.geometry, placex.geometry)
         LOOP
 
@@ -2782,4 +2782,4 @@ EXCEPTION
   WHEN others THEN return null;
 END;
 $$
-LANGUAGE plpgsql;
+LANGUAGE plpgsql IMMUTABLE;