Re: chop off non-meaningful digits

am  Tue, dem 14.11.2006, um  0:58:56 -0500 mailte Tom Lane folgendes:
> "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)

;-)

For this case:

test=*> select trim(trailing '.' from trim(trailing '0' from 1000.000));
 rtrim
-------
 1000
(1 row)


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net