X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/84ea0753d8d7861ff6a47a6eb29f072a1d342879..5d656891ba072d88b8b281d239d0dce9f7bd6a1c:/sql/tiger_import_start.sql?ds=sidebyside diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql index 5f916501..4b9c33fc 100644 --- a/sql/tiger_import_start.sql +++ b/sql/tiger_import_start.sql @@ -63,9 +63,8 @@ BEGIN END IF; IF out_parent_place_id IS NULL THEN - FOR location IN SELECT place_id FROM getNearestParellelRoadFeature(out_partition, linegeo) LOOP - out_parent_place_id := location.place_id; - END LOOP; + SELECT getNearestParallelRoadFeature(out_partition, linegeo) + INTO out_parent_place_id; END IF; IF out_parent_place_id IS NULL THEN