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

2002-09-22 Thread Karel Zak
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

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

2002-09-20 Thread Tom Lane
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

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

2002-09-20 Thread Peter Eisentraut
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