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
