[postgis-tickets] r15133 - fix numeric in interpolate_from_address

[Regina Obe]

Author: robe
Date: 2016-09-23 23:31:01 -0700 (Fri, 23 Sep 2016)
New Revision: 15133

Modified:
   trunk/extras/tiger_geocoder/geocode/interpolate_from_address.sql
Log:
fix numeric in interpolate_from_address
References #3640 for PostGIS 2.3.0 (trunk) better fix

Modified: trunk/extras/tiger_geocoder/geocode/interpolate_from_address.sql
===================================================================
--- trunk/extras/tiger_geocoder/geocode/interpolate_from_address.sql	2016-09-24 04:11:16 UTC (rev 15132)
+++ trunk/extras/tiger_geocoder/geocode/interpolate_from_address.sql	2016-09-24 06:31:01 UTC (rev 15133)
@@ -25,8 +25,8 @@
         RETURN NULL;
     END IF;
 
-	var_addr1 := to_number(COALESCE(NULLIF(trim(in_addr1),''),'0'), '999999');
-	var_addr2 := to_number(COALESCE(NULLIF(trim(in_addr2),''),'0'), '999999');
+	var_addr1 := to_number( CASE WHEN in_addr1 ~ '^[0-9]+$' THEN in_addr1 ELSE '0' END, '999999');
+	var_addr2 := to_number( CASE WHEN in_addr2 ~ '^[0-9]+$' THEN in_addr2 ELSE '0' END, '999999');
 
     IF geometrytype(in_road) = 'LINESTRING' THEN
       road := ST_Transform(in_road, utmzone(ST_StartPoint(in_road)) );