Re: Rounding - Mailing list pgsql-novice

From Tom Lane
Subject Re: Rounding
Date
Msg-id 26444.1065198248@sss.pgh.pa.us
Whole thread Raw
In response to Rounding  ("Chris Boget" <chris@wild.net>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: "Chris Boget"
Date:
Subject: Rounding
Next
From: Joe Conway
Date:
Subject: Re: Rounding