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) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster