ROUND function might help you there:
select round(1.2000::numeric, 1);
Regards,
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 13 Nov 2006 05:45:44 -0800, SunWuKung <Balazs(dot)Klein(at)t-online(dot)hu> wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>