From 9ab82a4f1f0a2fdd87feede0c422a51888cbfb89 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Mon, 20 Aug 2012 23:33:35 +0200 Subject: [PATCH] avoid reassigning address rank of place itself --- sql/functions.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/functions.sql b/sql/functions.sql index 382cb003..b1280cac 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1639,6 +1639,8 @@ BEGIN 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 -- 2.39.5