From: Sarah Hoffmann Date: Sat, 14 Apr 2012 06:56:07 +0000 (+0200) Subject: missing brackets in default name assignment X-Git-Tag: v2.0.0~88 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/1a9f05fd3f06698eaecb85a7e472561702167077 missing brackets in default name assignment --- diff --git a/sql/functions.sql b/sql/functions.sql index b61f52b2..c21ae1f9 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -920,7 +920,7 @@ BEGIN IF NEW.name ? 'name' AND NOT NEW.name ? ('name:'||default_language) THEN NEW.name := NEW.name || (('name:'||default_language) => (NEW.name -> 'name')); ELSEIF NEW.name ? ('name:'||default_language) AND NOT NEW.name ? 'name' THEN - NEW.name := NEW.name || ('name' => (NEW.name -> 'name:'||default_language)); + NEW.name := NEW.name || ('name' => (NEW.name -> ('name:'||default_language))); END IF; END IF; END IF; @@ -1271,7 +1271,7 @@ BEGIN IF NEW.name ? 'name' AND NOT NEW.name ? ('name:'||default_language) THEN NEW.name := NEW.name || (('name:'||default_language) => (NEW.name -> 'name')); ELSEIF NEW.name ? ('name:'||default_language) AND NOT NEW.name ? 'name' THEN - NEW.name := NEW.name || ('name' => (NEW.name -> 'name:'||default_language)); + NEW.name := NEW.name || ('name' => (NEW.name -> ('name:'||default_language))); END IF; END IF; END IF;