Re: numeric rounding

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Gezeala 'Eyah' BacuXo II <gezeala25(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: numeric rounding
Date: 2003-09-29 16:33:38
Message-ID: 20030929163338.GA32660@feivel.fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.00000001 to the computation but I also get the same results.. :(

Why 0.00000001? If you want to round to the second digit by cutting the
number you have to add 0.005.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Wells 2003-09-29 16:43:08 Postgres vs. Progress performance
Previous Message Bruce Momjian 2003-09-29 16:30:54 Re: Seeking insight from heavy lifters