Rounding - Mailing list pgsql-novice

From Chris Boget
Subject Rounding
Date
Msg-id 010201c389c2$b5ca7170$8c01a8c0@ENTROPY
Whole thread Raw
Responses Re: Rounding  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Rounding  (Joe Conway <mail@joeconway.com>)
Re: Rounding  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
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?

thnx,
Chris


pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: plperl db crash
Next
From: Tom Lane
Date:
Subject: Re: Rounding