Re: to_char(0,'FM999.99') outputs 0. - Mailing list 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@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

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