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

I suggest that an additional pattern filter be created that that only
removes padding white space (front and back) and does not affect trailing
zeros. (like FM)

Regards,
Jeff Post

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Bruce Momjian
> Sent: Wednesday, September 04, 2002 2:09 AM
> To: Karel Zak
> Cc: Andrew; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] to_char(0,'FM999.99') outputs 0.
>
>
>
> 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(at)zf(dot)jcu(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square,
> Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>