The following bug has been logged online:
Bug reference: 5150
Logged by: Gray
Email address: gray(at)ms-irk(dot)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