strip zeros from fractional part - Mailing list pgsql-general

From Giovanni M.
Subject strip zeros from fractional part
Date
Msg-id 9216699e0510031144k4430be19s3d00154b30757f9e@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi guys,

I am searching for a function that enables me to strip the trailing
zeros in the fractional part of a number (numeric type). For example a
number saved in a column of type numeric as such: 23.45000 would be
returned as 23.45

I can't find any function that does this in the documentation, does
something like this exist or do i need to write some custom function
myself?

Thanks for any help,

Giovanni Martina

--
A World of KEIGI
http://keigi.blogspot.com

pgsql-general by date:

Previous
From: J B
Date:
Subject: Integration with MS Sql Server
Next
From: "Dann Corbit"
Date:
Subject: Re: Integration with MS Sql Server