From: marc tobias <mtmail@gmx.net>
Date: Sat, 25 May 2019 18:43:38 +0000 (+0200)
Subject: exclude postcode ranges separated by colon from centre point calculation
X-Git-Tag: v3.4.0~39^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/10fbda702b539d3d931435e1cff82fc156a7e103?ds=sidebyside

exclude postcode ranges separated by colon from centre point calculation
---

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;