Subject numeric overflow with constants?
Author Richard Wesley
Why does the following generate a numeric overflow, and how do I
prevent it from doing so?

select 0.65000000000000002 / 0.34999999999999998 from rdb$database;

The query is machine generated from internal floating point
representations of .65 and .35 and I would like to know how to send
it to FB so that the right thing happens.

TIA
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com