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

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Andrew <sav(at)tut(dot)by>, pgsql-general(at)postgresql(dot)org
Subject: Re: to_char(0,'FM999.99') outputs 0.
Date: 2002-09-04 07:08:22
Message-ID: 20020904090822.F14392@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-09-04 07:09:19 Re: to_char(0,'FM999.99') outputs 0.
Previous Message dima 2002-09-04 06:43:57 Re: show ?