From a88c306cb5d3321a130107bd50b22758dab82593 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sun, 25 Sep 2016 03:41:38 +0000 Subject: [PATCH] tiger normalize, pagc_normalize integer out of range references #3641 for PostGIS 2.3.0 git-svn-id: http://svn.osgeo.org/postgis/trunk@15136 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/normalize/normalize_address.sql | 2 +- extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/extras/tiger_geocoder/normalize/normalize_address.sql b/extras/tiger_geocoder/normalize/normalize_address.sql index fa45d9ff5..747e705b5 100644 --- a/extras/tiger_geocoder/normalize/normalize_address.sql +++ b/extras/tiger_geocoder/normalize/normalize_address.sql @@ -697,7 +697,7 @@ BEGIN END IF; -- For address number only put numbers and stop if reach a non-number e.g. 123-456 will return 123 - result.address := to_number(substring(addressString, '[0-9]+'), '99999999999'); + result.address := to_number(substring(addressString, '[0-9]+'), '99999999'); --get rid of extraneous spaces before we return result.zip := trim(zipString); result.streetName := trim(result.streetName); diff --git a/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql b/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql index 4b0efae9f..0469cda3f 100644 --- a/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql +++ b/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql @@ -31,7 +31,7 @@ BEGIN COALESCE(', ' || var_parse_rec.city,'') || COALESCE(', ' || var_parse_rec.state, '') || COALESCE(' ' || var_parse_rec.zip,'') ) ; -- For address number only put numbers and stop if reach a non-number e.g. 123-456 will return 123 - result.address := to_number(substring(var_rec.house_num, '[0-9]+'), '99999999999'); + result.address := to_number(substring(var_rec.house_num, '[0-9]+'), '99999999'); --get rid of extraneous spaces before we return result.zip := COALESCE(var_rec.postcode,result.zip); result.streetName := trim(var_rec.name); -- 2.40.0