X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/cc17aa8d6b173351c26ead51507499cb8b481a4b..42ec67f63c36eb6317ec72b3071437d33d0ce3d0:/sql/update-postcodes.sql?ds=sidebyside

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;