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