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