Re: FM suffix in to_char Y/YY/YYY still screwy

Поиск
Список
Период
Сортировка
От Brendan Jurd
Тема Re: FM suffix in to_char Y/YY/YYY still screwy
Дата
Msg-id z2x37ed240d1004072056t9d9da28n446ff7692ea7b7a4@mail.gmail.com
обсуждение исходный текст
Ответ на FM suffix in to_char Y/YY/YYY still screwy  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 8 April 2010 06:46, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Not a lot of zero suppression happening there :-(.
>
> I believe the correct fix is to reduce the year mod 100 (or 10 or 1000)
> before feeding it to snprintf, rather than playing games with printing
> only part of the result string as the original and current code try to
> do.

I think you're right.  FM should behave as advertised, even for years.

Cheers,
BJ


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

Предыдущее
От: Dhiraj Lohiya
Дата:
Сообщение: Re: Enhancing phonetic search support for more languages - GSoC 2010
Следующее
От: Greg Stark
Дата:
Сообщение: A maze of twisty mailing lists all the same