From: Sarah Hoffmann Date: Thu, 16 May 2013 19:59:06 +0000 (+0200) Subject: fix c&p typo X-Git-Tag: v2.2.0~68 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/6ccfe99dc22447563488f0974a8afcda2b986883 fix c&p typo --- 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