Re: A creepy story about dates. How to prevent it? - Mailing list pgsql-general

From Tom Lane
Subject Re: A creepy story about dates. How to prevent it?
Date
Msg-id 10163.1056046140@sss.pgh.pa.us
Whole thread Raw
In response to Re: A creepy story about dates. How to prevent it?  (nolan@celery.tssi.com)
List pgsql-general
nolan@celery.tssi.com writes:
>>> Oracle's to_date function is not lax at all.
>>
>> Then we need to fix ours.  Karel?

> To make it as strict as Oracle's?  I'm not entirely convinced that is a
> Good Thing.

But to_date is a different animal, because it's working from a format
string that tells it exactly which field is which.  So as far as I can
see, there's no ambiguity; rather, the present behavior seems like it's
accepting demonstrably bogus data.

            regards, tom lane

pgsql-general by date:

Previous
From: Paul Ramsey
Date:
Subject: Re: [Fwd: PostGreSQL information]
Next
From: Pavel Stehule
Date:
Subject: Re: How to process mail using pgSQL?