From: Sarah Hoffmann Date: Wed, 15 Nov 2023 16:45:12 +0000 (+0100) Subject: php frontend: fix on-the-fly lookup of postcode areas X-Git-Tag: v4.4.0~82^2~1 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/383e3ccd2578bf8aa75849c4f60776ddb648082e php frontend: fix on-the-fly lookup of postcode areas --- diff --git a/lib-sql/functions/address_lookup.sql b/lib-sql/functions/address_lookup.sql index 5d2cb94d..26ce2073 100644 --- a/lib-sql/functions/address_lookup.sql +++ b/lib-sql/functions/address_lookup.sql @@ -262,7 +262,7 @@ BEGIN -- If the place had a postcode assigned, take this one only -- into consideration when it is an area and the place does not have -- a postcode itself. - IF location.fromarea AND location.isaddress + IF location.fromarea AND location_isaddress AND (place.address is null or not place.address ? 'postcode') THEN place.postcode := null; -- remove the less exact postcode