Re: [HACKERS] [GENERAL] to_timestamp() and quartersf

2010-03-03 Thread Bruce Momjian
Tom Lane wrote: Brendan Jurd dire...@gmail.com writes: For example, you're trying to import a date that is written as Wed 3rd March, Q1 2010. You might give to_date a format string like 'Dy FMDDTH Month, QQ ' and expect to get the correct answer. If we start throwing an error on the

Re: [HACKERS] [GENERAL] to_timestamp() and quartersf

2010-03-03 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Here is an updated patch that honors 'Q' only if the month has not been previously supplied: That's just weird. It's not even self-consistent much less unsurprising --- having the behavior be dependent on field order is really horrid. I think what people

Re: [HACKERS] [GENERAL] to_timestamp() and quartersf

2010-03-03 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Here is an updated patch that honors 'Q' only if the month has not been previously supplied: That's just weird. It's not even self-consistent much less unsurprising --- having the behavior be dependent on field order is really