X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/5ec25122f64523509b0cbc804c1be1f5f215c45c..6e39ed9573f1dcf5ea905815b2a33dfaf2deaa93:/sql/functions/aux_property.sql diff --git a/sql/functions/aux_property.sql b/sql/functions/aux_property.sql index cee5cfb2..6dd99eb2 100644 --- 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 - 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;