X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/8c3a0efe8b75a06279998e66a932d8a56c483961..7dfe645b5f2fcfc320264baad73f52c8003e857f:/sql/functions/postcode_triggers.sql

diff --git a/sql/functions/postcode_triggers.sql b/sql/functions/postcode_triggers.sql
index 96788d65..515b7666 100644
--- a/sql/functions/postcode_triggers.sql
+++ b/sql/functions/postcode_triggers.sql
@@ -27,8 +27,8 @@ BEGIN
     NEW.parent_place_id = 0;
     FOR location IN
       SELECT place_id
-        FROM getNearFeatures(partition, NEW.geometry, NEW.rank_search, '{}'::int[])
-        WHERE NOT isguess ORDER BY rank_address DESC LIMIT 1
+        FROM getNearFeatures(partition, NEW.geometry, NEW.rank_search)
+        WHERE NOT isguess ORDER BY rank_address DESC, distance asc LIMIT 1
     LOOP
         NEW.parent_place_id = location.place_id;
     END LOOP;
