Re: strip zeros from fractional part

Did you look at the round function?

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Giovanni M.
> Sent: Monday, October 03, 2005 11:45 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] strip zeros from fractional part
>
> 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
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq