SQL*Plus: Release 8.1.7.0.0 - Production on Thu Sep 29 16:03:55 2005
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> select 5/2 from dual;
5/2
----------
2.5
SQL>
----- Original Message ----
From: Dennis Jenkins <[EMAIL PROTECTED]>
To: [email protected]
Sent: Thursday, September 29, 2005 13:14:48
Subject: Re: [sqlite] Problem/Bug: "SELECT 5 / 2;" returns 2 ?
>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)
