Subject | Re: [ib-support] Re: CASTING ... (calculator thread) |
---|---|
Author | Bill Katelis |
Post date | 2002-05-31T01:33:15Z |
On the following version (from show version within isql linux mandrake 8
platform);
SQL> show version;
ISQL Version: LI-T1.0.0.796 Firebird 1.0
Firebird/linux Intel (access method), version "LI-T6.2.796 Firebird 1.0"
Firebird/linux Intel (remote server), version "LI-T6.2.796 Firebird 1.0/tcp
(conan.soundlogic.com.au)/P10"
Firebird/linux Intel (remote interface), version "LI-T6.2.796 Firebird
1.0/tcp (conan.soundlogic.com.au)/P10"
on disk structure version 10.0
SQL> select (3 / 10) * 3.333 from rdb$database;
=======================
0.9999000000000000
SQL> select (3.0 /10.0) * 3.333 from rdb$database;
=======================
0.9999000000000000
"Wilson, Fred" wrote:
platform);
SQL> show version;
ISQL Version: LI-T1.0.0.796 Firebird 1.0
Firebird/linux Intel (access method), version "LI-T6.2.796 Firebird 1.0"
Firebird/linux Intel (remote server), version "LI-T6.2.796 Firebird 1.0/tcp
(conan.soundlogic.com.au)/P10"
Firebird/linux Intel (remote interface), version "LI-T6.2.796 Firebird
1.0/tcp (conan.soundlogic.com.au)/P10"
on disk structure version 10.0
SQL> select (3 / 10) * 3.333 from rdb$database;
=======================
0.9999000000000000
SQL> select (3.0 /10.0) * 3.333 from rdb$database;
=======================
0.9999000000000000
"Wilson, Fred" wrote:
> BTW, for what it's worth, under FB1.0 (W2000), dialect 1 database
>
> select (3 / 10) * 3.333 from rdb$database;
> ======================================
> 1.000
>