PG not rejecting bad dates (was Re: Finding bogus dates) - Mailing list pgsql-general

From Ron Johnson
Subject PG not rejecting bad dates (was Re: Finding bogus dates)
Date
Msg-id 45B005FE.4010308@cox.net
Whole thread Raw
In response to Re: Finding bogus dates  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: PG not rejecting bad dates (was Re: Finding bogus dates)
Re: PG not rejecting bad dates (was Re: Finding bogus dates)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/18/07 17:22, Scott Ribe wrote:
>> But this won't work if one had a text column of dates in various
>> formats, right?
>
> Right. In my case I have bad data from a source I didn't control, exported
> via code that I do control which happens to output YYYY-MM-DD. Well, except
> that I don't do what I need to when MM or DD are more than 2 digits, but I'm
> going back to look at that again ;-)

Why didn't the PG engine reject these bad-date records at INSERT
time.  This smacks of something that MySQL would do...

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFsAX+S9HxQb37XmcRAg9NAJ4mdQXdp0tLDpiLcTaOVVrZgUMdSACgjTti
9iVMxYAWNIKOwtfm3T38Aac=
=Rpbe
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Finding bogus dates
Next
From: Tom Lane
Date:
Subject: Re: drive failre, corrupt data...