exclude postcode ranges separated by colon from centre point calculation

diff --git a/sql/update-postcodes.sql b/sql/update-postcodes.sql
index 1cbc88588aa0cf04ce486cff28ac7387ebf0604b..d59df15b67565cc4061aabba4a34d925f6e8111a 100644 (file)
--- 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'
        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;
 
        AND geometry IS NOT null
 GROUP BY country_code, pc;