Re: Over-rigidity in recent to_timestamp() rewrite

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Over-rigidity in recent to_timestamp() rewrite
Дата
Msg-id 23325.1237144515@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Over-rigidity in recent to_timestamp() rewrite  (Brendan Jurd <direvus@gmail.com>)
Список pgsql-hackers
Brendan Jurd <direvus@gmail.com> writes:
> Short version: I think using CC and AD/BC in combination with week
> dates would be downright weird, but I don't object to the patch.

I agree it's pretty weird, but I can't immediately see any reason that
it shouldn't (be allowed to) work.  It would only get interesting if
you want to posit that ISO years shouldn't be based on the Gregorian
calendar that far back.

Some experimentation shows that it doesn't work, or at least doesn't
give sane results, in pre-8.4 branches; I have not traced the code to
make sure but I think this is because of the other bug I noted with
passing the wrong year variable to the isoweek code.  I don't think
that's important enough to back-patch but it is worth getting it right
going forward.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Brendan Jurd
Дата:
Сообщение: Re: Over-rigidity in recent to_timestamp() rewrite
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Prepping to break every past release...