----- Original Message ----
From: [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, November 02, 2005 07:36:58
Subject: Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2
Consider the following SQL:
CREATE TABLE t1(a INTEGER, b REAL);
INSERT INTO t1 VALUES(5,5);
SELECT a/2, b/2 FROM t1;
D. Richard Hipp <[EMAIL PROTECTED]>
---
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> create table t1 (a integer, b real);
Table created.
SQL> insert into t1 values (5,5);
1 row created.
SQL> select a/2, b/2 from t1;
A/2 B/2
---------- ----------
2.5 2.5
SQL>
