Re: chop off non-meaningful digits

am Mon, dem 13.11.2006, um 5:45:44 -0800 mailte SunWuKung folgendes:
> What would be the easiest way to get back only the meaningful digits of
> a numeric value in a pgsql function? eg?
>
> 1.002 --> 1.002
> 1.020 --> 1.02
> 1.200 --> 1.2
> 1.000 --> 1

You can use trim for this:

test=*> select 1.020 + 0.01;
?column?
----------
1.030
(1 row)

test=*> select trim(trailing '0' from 1.020 + 0.01);
rtrim
-------
1.03
(1 row)

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