X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/26e30bf8e18f6c7a30cc056972d1399994309270..53eb9a5f1412d4d0942c1e18ef558ca0daf35034:/sql/functions.sql diff --git a/sql/functions.sql b/sql/functions.sql index e060a265..5ec98f20 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -2196,7 +2196,7 @@ BEGIN result := '{}'; prevresult := ''; - FOR location IN select * from get_addressdata(for_place_id,housenumber) where isaddress order by rank_address desc LOOP + FOR location IN select * from get_addressdata(for_place_id, housenumber) where isaddress order by rank_address desc LOOP currresult := trim(get_name_by_language(location.name, languagepref)); IF currresult != prevresult AND currresult IS NOT NULL AND result[(100 - location.rank_address)] IS NULL THEN result[(100 - location.rank_address)] := trim(get_name_by_language(location.name, languagepref));