From 6ccfe99dc22447563488f0974a8afcda2b986883 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 16 May 2013 21:59:06 +0200 Subject: [PATCH 1/1] fix c&p typo --- sql/functions.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/functions.sql b/sql/functions.sql index 5179195b..4f7493f3 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -3082,10 +3082,10 @@ BEGIN diameter := 0.001; -- 50 to 100 meters END IF; IF diameter > 0 THEN - IF NEW.rank_search >= 26 THEN + IF rank >= 26 THEN -- roads may cause reparenting for >27 rank places update placex set indexed_status = 2 where indexed_status = 0 and rank_search > rank and ST_DWithin(placex.geometry, placegeom, diameter); - ELSEIF NEW.rank_search >= 16 THEN + ELSEIF rank >= 16 THEN -- up to rank 16, street-less addresses may need reparenting update placex set indexed_status = 2 where indexed_status = 0 and rank_search > rank and ST_DWithin(placex.geometry, placegeom, diameter) and (rank_search < 28 or name is not null or addr_place is not null); ELSE -- 2.39.5