From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 9 Jun 2019 09:03:10 +0000 (+0200)
Subject: Merge pull request #1394 from mtmail/update-postcodes-without-colon
X-Git-Tag: v3.4.0~39
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/1f57d730dfdea8dc27c941cd040df9249ac66f38?hp=eebc72b2bc4a653ed7fef8900edc6e2b0295d001

Merge pull request #1394 from mtmail/update-postcodes-without-colon

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;