X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/503f9d19f19ded024e77e62cddb1d2a22bcac102..503baf46d58e414eca0ec19cdafd2229b372485f:/sql/update-postcodes.sql?ds=inline

diff --git a/sql/update-postcodes.sql b/sql/update-postcodes.sql
index 1cbc8858..d59df15b 100644
--- a/sql/update-postcodes.sql
+++ b/sql/update-postcodes.sql
@@ -6,7 +6,7 @@ SELECT country_code,
        ST_Centroid(ST_Collect(ST_Centroid(geometry))) as centroid
   FROM placex
  WHERE address ? 'postcode'
-       AND address->'postcode' NOT SIMILAR TO '%(,|;)%'
+       AND address->'postcode' NOT SIMILAR TO '%(,|;|:)%'
        AND geometry IS NOT null
 GROUP BY country_code, pc;