From 9bb81731f82be9488ae4ab8d635593317b57ed35 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 9 Apr 2017 10:06:31 +0200 Subject: [PATCH] fix operator precedence for hstore --- sql/functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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; -- 2.39.5