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@xxxxxx ----------------------------------------------------------------------