fix c&p typo

diff --git a/sql/functions.sql b/sql/functions.sql
index 5179195bb740cdef8bbfcec0b546fc5d00870b50..4f7493f3fc62873268930591f495f0e2fcbb937b 100644 (file)
--- 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
           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);
             -- 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
             -- 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