avoid reassigning address rank of place itself

diff --git a/sql/functions.sql b/sql/functions.sql
index 382cb003425816e5e1e75ea43859b507fe1c3a7b..b1280caca85f3d38a7fc95f2f6f3f0e1f6450029 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1639,6 +1639,8 @@ BEGIN
     location_rank_search := 0;
     location_distance := 0;
     location_parent := NULL;
     location_rank_search := 0;
     location_distance := 0;
     location_parent := NULL;

+    -- added ourself as address already
+    address_havelevel[NEW.rank_address] := true;

     -- RAISE WARNING '  getNearFeatures(%,''%'',%,''%'')',NEW.partition, place_centroid, search_maxrank, isin_tokens;
     FOR location IN SELECT * from getNearFeatures(NEW.partition, place_centroid, search_maxrank, isin_tokens) LOOP
 
     -- RAISE WARNING '  getNearFeatures(%,''%'',%,''%'')',NEW.partition, place_centroid, search_maxrank, isin_tokens;
     FOR location IN SELECT * from getNearFeatures(NEW.partition, place_centroid, search_maxrank, isin_tokens) LOOP