[postgis-tickets] [PostGIS] #3640: interpolate_from_address sometimes results in "" invalid for numeric

[PostGIS]

#3640: interpolate_from_address sometimes results in "" invalid for numeric
----------------------------+---------------------------
 Reporter:  robe            |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 2.2.3
Component:  tiger geocoder  |    Version:  2.2.x
 Keywords:                  |
----------------------------+---------------------------
 interpolate_from_address requires numeric assignment for var_addr1 and
 var_add2, but sometimes to_number returns with

 "" invalid for numeric.
 Ran into this while geocoding a couple million addresses

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3640>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.