Re: chop off non-meaningful digits

[Tom Lane <tgl@xxxxxxxxxxxxx>]

"SunWuKung" <Balazs.Klein@xxxxxxxxxxx> 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