Re: Rounding

Chris,

> Is there a way, internal in PG, that you can round to the
> nearest half decimal (rounded up or down)?  ie, I want to
> round 97.37 to 97.5 or 97.81 to 98.
> The closest thing I could see in the docs would take the
> 97.33 turning it into 97.4 and 97.81 to 97.8.  Is there some-
> thing I am missing?

No, but you could easily write your own function.   For example:

CREATE FUNCTION round_to_half ( NUMERIC )
RETURNS NUMERIC AS '
SELECT  (ROUND(($1 * 2))) / 2;
' LANGUAGE SQL IMMUTABLE STRICT;

--
Josh Berkus
Aglio Database Solutions
San Francisco