From: Sarah Hoffmann Date: Tue, 31 Jul 2012 06:27:59 +0000 (+0200) Subject: places that cannot be part of an address still should get an address themselves X-Git-Tag: v2.0.0~38 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/8ebc673ebf9ed3ceb2f278d2c0e42b836a34a37c?ds=inline;hp=-c places that cannot be part of an address still should get an address themselves --- 8ebc673ebf9ed3ceb2f278d2c0e42b836a34a37c diff --git a/sql/functions.sql b/sql/functions.sql index 25769785..2c4429bb 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -2235,14 +2235,14 @@ BEGIN END IF; IF for_place_id IS NULL THEN - select parent_place_id, calculated_country_code, housenumber, rank_address, postcode, name, class, type from placex + select parent_place_id, calculated_country_code, housenumber, rank_search, postcode, name, class, type from placex WHERE place_id = in_place_id and rank_address = 30 INTO for_place_id, searchcountrycode, searchhousenumber, searchrankaddress, searchpostcode, searchhousename, searchclass, searchtype; END IF; IF for_place_id IS NULL THEN for_place_id := in_place_id; - select calculated_country_code, housenumber, rank_address, postcode, null from placex where place_id = for_place_id + select calculated_country_code, housenumber, rank_search, postcode, null from placex where place_id = for_place_id INTO searchcountrycode, searchhousenumber, searchrankaddress, searchpostcode, searchhousename; END IF;