[postgis-tickets] r15136 - tiger normalize, pagc_normalize integer out of range

[Regina Obe]

Author: robe
Date: 2016-09-24 20:41:38 -0700 (Sat, 24 Sep 2016)
New Revision: 15136

Modified:
   trunk/extras/tiger_geocoder/normalize/normalize_address.sql
   trunk/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql
Log:
tiger normalize, pagc_normalize integer out of range
references #3641 for PostGIS 2.3.0

Modified: trunk/extras/tiger_geocoder/normalize/normalize_address.sql
===================================================================
--- trunk/extras/tiger_geocoder/normalize/normalize_address.sql	2016-09-24 07:22:04 UTC (rev 15135)
+++ trunk/extras/tiger_geocoder/normalize/normalize_address.sql	2016-09-25 03:41:38 UTC (rev 15136)
@@ -697,7 +697,7 @@
   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);

Modified: trunk/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql
===================================================================
--- trunk/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql	2016-09-24 07:22:04 UTC (rev 15135)
+++ trunk/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql	2016-09-25 03:41:38 UTC (rev 15136)
@@ -31,7 +31,7 @@
    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);