Postgres Pro
Downloads
Home   >   mailing lists

Re: chop off non-meaningful digits - Mailing list pgsql-general

From Tom Lane
Subject Re: chop off non-meaningful digits
Date
Msg-id 20416.1163483936@sss.pgh.pa.us
Whole thread Raw
In response to Re: chop off non-meaningful digits  ("SunWuKung" <Balazs.Klein@t-online.hu>)
Responses Re: chop off non-meaningful digits
List pgsql-general
Tree view 
"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)


            regards, tom lane

pgsql-general by date:

Previous
From: Igor Shevchenko
Date:
Subject: can't start postgresql
Next
From: "A. Kretschmer"
Date:
Subject: Re: chop off non-meaningful digits