[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.

More information about the postgis-users mailing list