From 8ebc673ebf9ed3ceb2f278d2c0e42b836a34a37c Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 31 Jul 2012 08:27:59 +0200 Subject: [PATCH] places that cannot be part of an address still should get an address themselves --- sql/functions.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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; -- 2.39.5