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

From SunWuKung
Subject chop off non-meaningful digits
Date
Msg-id 1163425544.031647.208480@m7g2000cwm.googlegroups.com
Whole thread Raw
Responses Re: chop off non-meaningful digits
Re: chop off non-meaningful digits
Re: chop off non-meaningful digits
List pgsql-general
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

Thanks
SWK


pgsql-general by date:

Previous
From: Rick Schumeyer
Date:
Subject: Re: encoding advice requested
Next
From: Walter Vaughan
Date:
Subject: Re: Trying to Install PhP-4 Module for PostgreSQL from