Re: chop off non-meaningful digits

"SunWuKung" <Balazs.Klein@t-online.hu> 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