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