Merge pull request #1964 from lonvia/remove-postcodes-with-colon

[nominatim.git] / sql / functions / aux_property.sql

diff --git a/sql/functions/aux_property.sql b/sql/functions/aux_property.sql
index cee5cfb2e3619145b4b10ff856d6057d54b59b3a..6dd99eb241436e286c65602d3b5be3b94b1a133f 100644 (file)
--- a/sql/functions/aux_property.sql
+++ b/sql/functions/aux_property.sql
@@ -28,8 +28,8 @@ BEGIN
   END IF;
 
   IF out_parent_place_id IS NULL THEN
   END IF;
 
   IF out_parent_place_id IS NULL THEN

-    FOR location IN SELECT place_id FROM getNearestRoadFeature(out_partition, place_centroid) LOOP
-      out_parent_place_id := location.place_id;
+    SELECT getNearestRoadPlaceId(out_partition, place_centroid)
+      INTO out_parent_place_id;

     END LOOP;
   END IF;
 
     END LOOP;
   END IF;