Re: [GENERAL] to_timestamp() and quartersf

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] to_timestamp() and quartersf
Дата
Msg-id 13221.1267637850@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] to_timestamp() and quartersf  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: [GENERAL] to_timestamp() and quartersf
Список pgsql-hackers
Bruce Momjian <bruce@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 would actually want for this type of situation is
a way to specify "there is an integer here but I want to ignore it".
Q as it's presently constituted accomplishes that, though it is not
documented as doing so.  Brendan's comment about quoted text is
interesting, but it doesn't really solve the problem because of the
possibility of the integer field being variable width.
        regards, tom lane


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

Предыдущее
От: Brendan Jurd
Дата:
Сообщение: Re: [GENERAL] to_timestamp() and quarters
Следующее
От: Grzegorz Jaskiewicz
Дата:
Сообщение: Re: double and numeric conversion