X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/16053e81bf9dacc9761de3c833edd0d1c5b20831..dc2911ae7257b0b1d95eec922e17361a458d213f:/sql/functions.sql

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
