The following bug has been logged online:
Bug reference: 3475
Logged by: vasile
Email address: vasile.halosta@gmail.com
PostgreSQL version: 8.2.4
Operating system: Centos 4.4
Description: SQL: 7/2 = 3
Details:
When you divide 2 int the result is also int, is truncated:
On pgsql:
pg=# select 7/2;
?column?
----------
3
(1 row)
I know in c when you have to int operator the result is also int, but I
think this is not a good idea in SQL.