On 2009-01-29, Steve Crawford <scrawf...@pinpointresearch.com> wrote: > >>> 3. Date handling >>> Sometimes I've got data with invalid dates and it would be great if it >>> could replace all the bad ones with, say "0000-00-00". >>>
0000-00-00 doesn't fit in a date column. perhaps you could use null? write a function that casts and catches the exception caused when bad dates are attempted and returens null, use it to translate your data. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general