Re: chop off non-meaningful digits

From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: chop off non-meaningful digits
Date: 2006-11-13 13:51:06
Message-ID: 4558784A.14174.944A47@rod.iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 13 Nov 2006 at 5:45, SunWuKung wrote:

> What would be the easiest way to get back only the meaningful digits of
> a numeric value in a pgsql function? eg?

There are various rounding functions built in... have a look at
http://www.postgresql.org/docs/8.1/static/functions-math.html

--Ray.

----------------------------------------------------------------------

Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod(at)iol(dot)ie
----------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-11-13 13:53:00 Re: chop off non-meaningful digits
Previous Message Walter Vaughan 2006-11-13 13:45:58 Re: Trying to Install PhP-4 Module for PostgreSQL from