On Fri, Sep 20, 2002 at 09:24:00PM +0200, Peter Eisentraut wrote:
> 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. T
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> 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.
No doubt, but it's what Oracle does (see
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 sci