Re: [HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2008-04-27 Thread Brendan Jurd
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm picking this one up again, since my refactor of formatting.c has been applied, and I seem to be done playing with psql for the time being =) -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.7 (GNU/Linux) Comment: http://getfiregpg.org

Re: [HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2007-07-17 Thread Brendan Jurd
On 4/3/07, Bruce Momjian [EMAIL PROTECTED] wrote: Because this patch was not completed, I have added it to the TODO list: * Fix to_date()-related functions to consistently issue errors http://archives.postgresql.org/pgsql-hackers/2007-02/msg00915.php I'm now taking another run at this

Re: [HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2007-07-17 Thread Tom Lane
Brendan Jurd [EMAIL PROTECTED] writes: * Fix to_date()-related functions to consistently issue errors http://archives.postgresql.org/pgsql-hackers/2007-02/msg00915.php I'm now taking another run at this issue. Here's what I've got in mind. This is all good but I think that self-inconsistent

Re: [HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2007-07-17 Thread Brendan Jurd
On 7/18/07, Tom Lane [EMAIL PROTECTED] wrote: This is all good but I think that self-inconsistent format strings are not really the main source of to_date problems. Most of the complaints I've seen arise from to_date plowing ahead to deliver a ridiculous answer when the input data string

Re: [HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2007-02-17 Thread Martijn van Oosterhout
On Sat, Feb 17, 2007 at 02:41:32PM +1100, Brendan Jurd wrote: My gut reaction at first was to go with the former approach. It's programmatically more simple, and it's easier to explain in documentation/error messages. But then it occurred to me that one of the use cases for to_date is

Re: [HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2007-02-17 Thread Brendan Jurd
On 2/17/07, Martijn van Oosterhout kleptog@svana.org wrote: On Sat, Feb 17, 2007 at 02:41:32PM +1100, Brendan Jurd wrote: My gut reaction at first was to go with the former approach. It's programmatically more simple, and it's easier to explain in documentation/error messages. But then it

Re: [HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2007-02-17 Thread Chad Wagner
On 2/17/07, Brendan Jurd [EMAIL PROTECTED] wrote: I just looked through the Oracle documentation, and it is conspicuously silent on the topic of invalid format patterns. Much like ours in fact. On the case of the format: -MM-DD J, if J is the same date as -MM-DD then Oracle appears

[HACKERS] Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)

2007-02-16 Thread Brendan Jurd
On 2/17/07, Alvaro Herrera [EMAIL PROTECTED] wrote: Bruce Momjian escribió: Maybe now would be an appropriate time to discuss the open questions in the submitting email: Brendan Jurd wrote: I'd also like to raise the topic of how conversion from text to ISO week dates should be