Re: [HACKERS] [PATCHES] to_char(FM9.9) bug fix
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. The FM modifier means to omit unnecessary In the code it's commented as "terrible Ora format" :-) > trailing stuff. There is no reasonable business or scientific custom to > leave a trailing point after a number. I think so. I don't know who can use format number like '1.' or '.0'. Can somebody explain why Oracle implement it, who use it? > Or perhaps a more pragmatic question is, how would I print a number > without the trailing point? Don't use FM or use FM9.0 Examples: 'SVRMGR' = Oracle8 Release 8.0.5.0.0 'test=#' = PostgreSQL 7.3b1 test=# select to_char(1, 'FM9.9'); to_char - 1. SVRMGR> select to_char(1, 'FM9.9') from dual; TO_C 1. test=# select to_char(1, '9.9'); to_char - 1.0 SVRMGR> select to_char(1, '9.9') from dual; TO_C 1.0 test=# select to_char(1, 'FM9.0'); to_char - 1.0 SVRMGR> select to_char(1, 'FM9.0') from dual; TO_C 1.0 -- Karel Zak <[EMAIL PROTECTED]> http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] [PATCHES] to_char(FM9.9) bug fix
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 tests posted to the lists by several people) and to_char exists to duplicate Oracle behavior. This is hardly the silliest aspect of to_char's definition, IMHO ... regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] [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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly