[postgis-users] shp2pgsql and ''::numeric
pramsey at refractions.net
Fri Sep 26 21:39:06 PDT 2003
It is also worth pointing out that the int/bigint determination code
seems to be deciding on bigint an awful lot. bigint shouldn't be used
unless the field definition is number(9,0) or higher.
> 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.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
| Paul Ramsey
| Refractions Research
| Email: pramsey at refractions.net
| Phone: (250) 885-0632
More information about the postgis-users