On 2009-01-29, Steve Crawford <scrawford(at)pinpointresearch(dot)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.
In response to
pgsql-general by date
|Next:||From: Mohamed||Date: 2009-01-31 19:21:17|
|Subject: Indices types, what to use. Btree, Hash, Gin or Gist|
|Previous:||From: Jasen Betts||Date: 2009-01-31 18:53:49|
|Subject: Re: getting no days problem|