From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 9 Apr 2017 08:06:31 +0000 (+0200)
Subject: fix operator precedence for hstore
X-Git-Tag: v3.0.0~42^2~1
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/9bb81731f82be9488ae4ab8d635593317b57ed35

fix operator precedence for hstore
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 1c760378..eb2ab5de 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1183,7 +1183,7 @@ BEGIN
         i := getorcreate_housenumber_id(make_standard_name(NEW.address->'conscriptionnumber'));
         IF NEW.address ? 'streetnumber' THEN
             i := getorcreate_housenumber_id(make_standard_name(NEW.address->'streetnumber'));
-            NEW.housenumber := NEW.address->'conscriptionnumber' || '/' || NEW.address->'streetnumber';
+            NEW.housenumber := (NEW.address->'conscriptionnumber') || '/' || (NEW.address->'streetnumber');
         ELSE
             NEW.housenumber := NEW.address->'conscriptionnumber';
         END IF;