Re: [sqlite] Problem/Bug: "SELECT 5 / 2;" returns 2 ?

[René Tegel]

MySQL 4.0.24-standard:
#SELECT 5 /2
 5/2
2.50


Dennis Jenkins wrote:

Just out of curiosity: Maybe someone can report the result of 'SELECT 5 / 2;' on MySql, SQLServer, and others?

devl=# SELECT 5 / 2;
?column?
----------
       2
(1 row)

devl=# select 5.0 / 2;
     ?column?
--------------------
2.5000000000000000
(1 row)

devl=# select 5 / 2.0;
     ?column?
--------------------
2.5000000000000000
(1 row)

devl=# select version();
                                           version

------------------------------------------------------------------------------------------------ PostgreSQL 8.0.3 on i386-portbld-freebsd5.4, compiled by GCC cc (GCC) 3.4.2 [FreeBSD] 20040728

(1 row)