Re: A creepy story about dates. How to prevent it?

On Wed, 18 Jun 2003, Tom Lane wrote:

> "scott.marlowe" <scott.marlowe@ihs.com> writes:
> > That reminds me, did we get the date parsing fixed so that you can't 
> > insert 22/03/2003 into a european database (or conversely, 03/22/2003 into 
> > a US database) ?  I.e the problem where the date parser assumed you meant 
> > it the other way...
> 
> IIRC, there was no consensus that that's a bug.

I thought there was, and someone had said they were gonna fix it.

IMHO it is a bug.  We don't let postgresql "guess" about a lot of more 
obvious things (i.e. int4 to int8 casting, etc...) and letting it guess 
about dates makes it non-ACID compliant. 

If it isn't a bug, how do I implement a check constraint to stop it from 
happening?  I'd like to know my database accepts properly formatted input 
and rejects the rest.  That's what the C in ACID means, right?