[postgis-devel] Issue 121 in postgis: update tiger_geocoder to run in PostgreSQL 8.3 (patch attached)

[codesite-noreply at google.com]

Comment #2 on issue 121 by cdwinslow: update tiger_geocoder to run in  
PostgreSQL 8.3 (patch attached)
http://code.google.com/p/postgis/issues/detail?id=121

Looked at this again today long enough to make a patch with only one cast  
per
comparison.  As part of the process, lpad() is no longer needed outside the
pretty-printer function.

It seems the problem is that the lookup tables built/used by the geocoder  
use numeric
fields for (zip,state,county...) codes while the analogous fields in the  
TIGER data
are text.

Attachments:
	tiger_geocoder-pg-8.3-b.patch  9.2 KB

--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings