From: Sarah Hoffmann Date: Mon, 16 Apr 2018 18:16:11 +0000 (+0200) Subject: fix variable name X-Git-Tag: v3.2.0~79^2~5 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/b8113abd930b3af1e50fa72514803962dd964f79 fix variable name --- diff --git a/sql/functions.sql b/sql/functions.sql index e89013bb..b39d59b7 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1786,7 +1786,7 @@ RAISE WARNING 'Address found % -> %', addr_item.key, addr_item.value; END IF; IF addr_item.key = 'is_in' THEN -- is_in items need splitting - isin := regexp_split_to_array(NEW.isin, E'[;,]'); + isin := regexp_split_to_array(addr_item.value, E'[;,]'); IF array_upper(isin, 1) IS NOT NULL THEN FOR i IN 1..array_upper(isin, 1) LOOP address_street_word_id := get_name_id(make_standard_name(isin[i]));