Search Postgresql Archives

Re: chop off non-meaningful digits

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yep, I think this is it:
select trim(trailing '0.' from 1.020)

Many thanks.
SWK

"A. Kretschmer" wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux