From cc43bedd2145d1cfc740b0635df3746b620b4778 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sat, 5 May 2012 11:38:26 +0200 Subject: [PATCH] modifiers to encourage use of indices --- sql/functions.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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; -- 2.45.2