X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/90ac15748eb4b2718c43337f23355dfa8e9048a8..3266daa8fde98acc1fe4c9929cb5be3aed662add:/lib-sql/functions/address_lookup.sql?ds=inline diff --git a/lib-sql/functions/address_lookup.sql b/lib-sql/functions/address_lookup.sql index 0eada698..2bbfcd5c 100644 --- a/lib-sql/functions/address_lookup.sql +++ b/lib-sql/functions/address_lookup.sql @@ -320,6 +320,11 @@ BEGIN location := ROW(null, null, null, hstore('ref', place.postcode), 'place', 'postcode', null, null, false, true, 5, 0)::addressline; RETURN NEXT location; + ELSEIF place.address is not null and place.address ? 'postcode' + and not place.address->'postcode' SIMILAR TO '%(,|;)%' THEN + location := ROW(null, null, null, hstore('ref', place.address->'postcode'), 'place', + 'postcode', null, null, false, true, 5, 0)::addressline; + RETURN NEXT location; END IF; RETURN;