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@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Bruce Momjian
> Sent: Wednesday, September 04, 2002 2:09 AM
> To: Karel Zak
> Cc: Andrew; pgsql-general@postgresql.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@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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>