Opened 12 years ago

Closed 12 years ago

#1366 closed defect (fixed)

geocode_intersection returns nothing with lowercase state

Reported by: arencambre Owned by: robe
Priority: medium Milestone: PostGIS 2.0.0
Component: tiger geocoder Version: master
Keywords: Cc: aren@…

Description

If I run this:

SELECT addy, ST_X(ST_SetSRID(geomout,4326)), ST_Y(ST_SetSRID(geomout,4326)), rating
FROM geocode_intersection('ross', 'harwood', 'tx', 'dallas')

…I get no results.

If I run this:

SELECT addy, ST_X(ST_SetSRID(geomout,4326)), ST_Y(ST_SetSRID(geomout,4326)), rating
FROM geocode_intersection('ross', 'harwood', 'TX', 'dallas')

…I get expected results.

The only difference is capitalization of the state field: if not uppercase, I get no results.

Change History (1)

comment:1 by robe, 12 years ago

Resolution: fixed
Status: newclosed

fixed at r8355

Note: See TracTickets for help on using tickets.