Re: to_char(0,'FM999.99') outputs 0.

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: to_char(0,'FM999.99') outputs 0.
Дата
Msg-id 200209040709.g8479Kw22435@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: to_char(0,'FM999.99') outputs 0.  (Karel Zak <zakkr@zf.jcu.cz>)
Ответы Re: to_char(0,'FM999.99') outputs 0.  ("Jeff Post" <postjeff@uwm.edu>)
Список pgsql-general
Thanks for the update.

---------------------------------------------------------------------------

Karel Zak wrote:
> On Tue, Sep 03, 2002 at 01:01:26PM -0400, Bruce Momjian wrote:
> >
> > I can see no reason that there is a period after 0 but not after 1.
> > Sure looks like a bug to me.  Added to TODO:
> >
> >    * to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not
>
>  Oracle result:
>
> SVRMGR> select to_char(0,'FM999.99') from dual;
> TO_CHAR
> -------
> 0.
> 1 row selected.
>
> SVRMGR> select to_char(1,'FM999.99') from dual;
> TO_CHAR
> -------
> 1.
> 1 row selected.
>
>
>  You're right result of to_char(1,'FM999.99') in PG is bug.
>
>  There are more things in my TODO, but sorry I haven't time for 7.3. I must
> finish some other project in this time. All will fixed in 7.4.
>
>     Karel
>
> --
>  Karel Zak  <zakkr@zf.jcu.cz>
>  http://home.zf.jcu.cz/~zakkr/
>
>  C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Karel Zak
Дата:
Сообщение: Re: to_char(0,'FM999.99') outputs 0.
Следующее
От: Christoph Dalitz
Дата:
Сообщение: Re: show ?