BUG #3475: SQL: 7/2 = 3 - Mailing list pgsql-bugs

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.