From 7d520bf448191d12b96265fb066dd7039cde041c Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 1 Dec 2020 22:15:51 +0100 Subject: [PATCH 1/1] also add explicit cast for varchar --- sql/functions/address_lookup.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/sql/functions/address_lookup.sql b/sql/functions/address_lookup.sql index dfd5a953..34ef7ca7 100644 --- a/sql/functions/address_lookup.sql +++ b/sql/functions/address_lookup.sql @@ -111,7 +111,7 @@ BEGIN --then query tiger data -- %NOTIGERDATA% IF 0 THEN IF place IS NULL AND in_housenumber >= 0 THEN - SELECT parent_place_id as place_id, 'us' as country_code, + SELECT parent_place_id as place_id, 'us'::varchar(2) as country_code, in_housenumber::text as housenumber, postcode, 'place' as class, 'house' as type, null::hstore as name, null::hstore as address, @@ -125,7 +125,7 @@ BEGIN -- %NOAUXDATA% IF 0 THEN IF place IS NULL THEN - SELECT parent_place_id as place_id, 'us' as country_code, + SELECT parent_place_id as place_id, 'us'::varchar(2) as country_code, housenumber, postcode, 'place' as class, 'house' as type, null::hstore as name, null::hstore as address, @@ -191,7 +191,7 @@ BEGIN --RAISE WARNING '%',location; IF location.rank_address < 4 THEN -- no country locations for ranks higher than country - place.country_code := NULL; + place.country_code := NULL::varchar(2); ELSEIF place.country_code IS NULL AND location.country_code IS NOT NULL THEN place.country_code := location.country_code; END IF; -- 2.45.2