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