Postgres Pro
Downloads
Home   >   mailing lists

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 9360.1056039764@sss.pgh.pa.us
Whole thread Raw
In response to Re: A creepy story about dates. How to prevent it?  (Jean-Luc Lachance <jllachan@nsd.ca>)
Responses Re: A creepy story about dates. How to prevent it?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: A creepy story about dates. How to prevent it?  (Ron Johnson <ron.l.johnson@cox.net>)
Re: A creepy story about dates. How to prevent it?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> Shouldn't dates be validated using the *LOCALE setting and not try to
> guess?

It would make sense to offer a "strict" mode in which the date order
has to be what DateStyle suggests.  I'm astonished that no one seems
to get the point that there are also good uses for "lax" parsing.

            regards, tom lane

pgsql-general by date:

Previous
From: "Jimmie H. Apsey"
Date:
Subject: Re: A View to Share
Next
From: Tom Lane
Date:
Subject: Re: A creepy story about dates. How to prevent it?