Subject Re: [ib-support] Re: CASTING ... (calculator thread)
Author Bill Katelis
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:

> BTW, for what it's worth, under FB1.0 (W2000), dialect 1 database
>
> select (3 / 10) * 3.333 from rdb$database;
> ======================================
> 1.000
>