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