[postgis-users] shp2pgsql and ''::numeric
strk
strk at keybit.net
Fri Sep 26 18:24:20 PDT 2003
shp2pgsql (as of latest cvs version)
generates empty strings as the values for numeric fields.
If you could use DBFReadAttribute instead of DBFReadStringAttribute
you might get a better control over values.
What I think is that the field value is the number 0, so
DBFIsAttributeNULL returns false while DBFReadStringAttribute
returns '' ( the empty string! ).
Can you please check this (it requires duplicating the type
detecting code used at table creation time ( or maybe cache
that info).
NOTE that the problem emerge only for numerics valued 0.
TIA
--strk;
More information about the postgis-users
mailing list