"Chris Boget" <chris@wild.net> writes:
> 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.
Double the value, round to integer, divide by 2?
regards, tom lane