X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/5ec25122f64523509b0cbc804c1be1f5f215c45c..22800d7d59f952ced174008669e5eddadf1117d8:/sql/functions/aux_property.sql?ds=sidebyside 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;