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: sqlite-users@sqlite.org 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)