Subject | RE: [ib-support] Casting problem |
---|---|
Author | Veli-Matti Hurskainen |
Post date | 2001-08-13T09:02:29Z |
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:
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.