Horton

BUG #5150: math bug

Gray <gray@ms-irk.ru>

View thread View on postgr.es
From: "Gray" <gray@ms-irk.ru>
To: pgsql-bugs@postgresql.org
Date: 2009-10-30T05:39:10Z
Lists: pgsql-bugs 
The following bug has been logged online:

Bug reference:      5150
Logged by:          Gray
Email address:      gray@ms-irk.ru
PostgreSQL version: 8.2.6
Operating system:   i686-pc-linux-gnu
Description:        math bug
Details: 

select 1/3*3,(1.0/3.0)*3.0,floor((1.0/3.0)*3.0);

returns
0, 1, 0