[postgis-devel] DBF-Column type boolen and date

[strk at refractions.net]

On Wed, Jan 11, 2006 at 10:35:19AM -0800, Paul Ramsey wrote:
> DBF Date is an unrestricted YYYYMMDD format string of numbers, and as  
> such often contains invalid dates, which PostgreSQL will dutifully  
> fail to accept.  For example, it is not uncommon to find 00000000 in  
> a DBF date field, which is year 0 (ok....), month 0 and day 0 (bzzzzt).

00000000 is already handled to represent the NULL value
(interpretation found in shapelib).

Other invalid dates are still a problem.
Maybe we should add explicit switches to shp2pgsql and pgsql2shp
to actually use those types ?

--strk;