Re: SQL error: function round(double precision, integer) does not exist

TJ,

> SQL error:
> ERROR:  function round(double precision, integer) does not exist

> http://www.postgresql.org/docs/7.4/static/functions-math.html
> show that round(numeric,int) should work ok.
> If I use round() without a second argument, it works OK, but
> this gives a loss of precision which I do not want.

NUMERIC and FLOAT are different data types.   Do:

round({value}::NUMERIC, {places})

-- 
Josh Berkus
Aglio Database Solutions
San Francisco