Postgres Pro
Downloads
Home   >   mailing lists

BUG #3791: Bug in aritmethic calculations - Mailing list pgsql-bugs

From Michailas
Subject BUG #3791: Bug in aritmethic calculations
Date
Msg-id 200711300918.lAU9INl5025926@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3791: Bug in aritmethic calculations  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Re: BUG #3791: Bug in aritmethic calculations  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3791
Logged by:          Michailas
Email address:      michailas.p@gmail.com
PostgreSQL version: 8.2.4-2
Operating system:   Debian
Description:        Bug in aritmethic calculations
Details:

postgres=# SELECT abs(300 - 200)/200*100 as bad, abs(300-200)*100/200 as
good;

 bad | good
-----+------
   0 |   50
(1 row)

pgsql-bugs by date:

Previous
From: "Mike C."
Date:
Subject: BUG #3790: pg_restore error canceling statement due to user request
Next
From: "Gevik Babakhani"
Date:
Subject: Re: BUG #3791: Bug in aritmethic calculations