fix operator precedence for hstore

diff --git a/sql/functions.sql b/sql/functions.sql
index 1c7603780c61c95723b7114914b978355c9d56eb..eb2ab5de0c6e04819e643b93b30334c596cb77b2 100644 (file)
--- 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;