The following bug has been logged online:
Bug reference: 2418
Logged by: James
Email address: james(at)mercstudio(dot)com
PostgreSQL version: 8.1
Operating system: Microsoft Windows XP Professional
Description: number & date & time
Details:
hi,
we would like to have convinience data conversion from datatype number of
value '' as null and datatype date / timestamp / timestampz of value '' as
null...
so far, postgresql will reject those value for number and date / time field
when it's empty string '' (as invalid date value or invalid number value)
it would be nice to have it auto converted :)