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