Opened 6 years ago

Closed 6 years ago

#3640 closed defect (fixed)

interpolate_from_address sometimes results in "" invalid for numeric

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.2.3
Component: tiger geocoder Version: 2.2.x
Keywords: Cc:

Description

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

Change History (3)

comment:1 by robe, 6 years ago

In 15132:

fix numeric in interpolate_from_address
References #3640 for PostGIS 2.3.0 (trunk)

comment:2 by robe, 6 years ago

In 15133:

fix numeric in interpolate_from_address
References #3640 for PostGIS 2.3.0 (trunk) better fix

comment:3 by robe, 6 years ago

Resolution: fixed
Status: newclosed

In 15142:

fix numeric in interpolate_from_address
Closes #3640 for PostGIS 2.2.3

Note: See TracTickets for help on using tickets.