[postgis-users] shp2pgsql and ''::numeric

[Paul Ramsey]

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.

strk wrote:
> 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;
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_