X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/cc17aa8d6b173351c26ead51507499cb8b481a4b..10fbda702b539d3d931435e1cff82fc156a7e103:/sql/update-postcodes.sql

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;