"SunWuKung" <[EMAIL PROTECTED]> writes: > Yep, I think this is it: > select trim(trailing '0.' from 1.020)
Um, I think not: regression=# select trim(trailing '0.' from 1000.000); rtrim ------- 1 (1 row) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: 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