Re: [PATCHES] to_char(FM9.9) bug fix

Karel Zak writes:

> test=# select to_char(0,'FM9.9');
>  to_char
> ---------
>  0.
> (1 row)
>
> test=# select to_char(1,'FM9.9');
>  to_char
> ---------
>  1.
> (1 row)

I find this highly bizzare.  The FM modifier means to omit unnecessary
trailing stuff.  There is no reasonable business or scientific custom to
leave a trailing point after a number.

Or perhaps a more pragmatic question is, how would I print a number
without the trailing point?

-- 
Peter Eisentraut   peter_e@gmx.net