Subject RE: [ib-support] Casting problem
Author Veli-Matti Hurskainen
Not that it were a big problem. It seems it's not the operations
themselves, but the casting:
SQL> select 1 + 1 from rdb$database;
============
2
SQL> select cast(1 + 1 as varchar(8)) from rdb$database;
========
2.00000
SQL> select 1.01 + 1.01 from rdb$database;
=======================
2.020000000000000

Whatever
VmH

At 18:48 11.8.2001 -0400, Sean wrote:
>Under dialect 1 values are treated, without any consideration of the
>precision/decimals, and hence the result.