On Mon, Sep 29, 2003 at 12:47:05AM -0700, Gezeala 'Eyah' BacuXo II wrote:
> You can see I already added a value of 0.0001 to the computation but I also get
> the same results.. :(
Why 0.0001? If you want to round to the second digit by cutting the
number you have to add 0.005.
Michael
--
On Mon, Sep 29, 2003 at 12:47:05AM -0700, Gezeala 'Eyah' Bacuño II wrote:
> my problem is my function just won't round some numbers properly..
> what i want it to do is like this.
>
> example:
>
> 721.875 = 721.88
a=> select round(721.875, 2);
round
721.88
(1 row)
--
Alvaro Herrera
