From dc2911ae7257b0b1d95eec922e17361a458d213f Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 2 Jul 2017 11:32:32 +0200 Subject: [PATCH] normalize postcodes before adding to location tables --- sql/functions.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/sql/functions.sql b/sql/functions.sql index 44918774..1940ea75 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -617,10 +617,9 @@ BEGIN x := deleteLocationArea(partition, place_id, rank_search); -- add postcode only if it contains a single entry, i.e. ignore postcode lists - IF in_postcode IS NULL OR in_postcode similar to '%(,|;)%' THEN - postcode := NULL; - ELSE - postcode := in_postcode; + postcode := NULL; + IF in_postcode is not null AND in_postcode not similar to '%(,|;)%' THEN + postcode := upper(trim (both ' ' from in_postcode)); END IF; IF ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon') THEN -- 2.39.5