id summary reporter owner description type status priority milestone component version resolution keywords cc 2899 geocode limit 1 not returning best answer robe robe "Just found a bug in my limit 1 logic for geocoding. {{{ SELECT g.rating, pprint_addy(addy) As m_addr FROM geocode('22 Minnow Ln, Westbrook, CT 06498',1) As g; }}} Yields a stupid answer with rating 59 while: {{{ rating | m_addr --------+------------------------------------------ 59 | 22 S Main St, Westbrook Center, CT 06498 }}} While not using limit {{{ SELECT g.rating, pprint_addy(addy) As m_addr FROM geocode('22 Minnow Ln, Westbrook, CT 06498') As g; }}} {{{ rating | m_addr --------+------------------------------------------ 0 | 22 Minnow Ln, Westbrook Center, CT 06498 (1 row) }}} " defect closed high PostGIS 2.1.4 tiger geocoder 2.1.x fixed history