CREATE PROCEDURE FLOAT_PROBLA
RETURNS (RESULT FLOAT)
AS
BEGIN
select
2 / cast (3 as float)
from dual
into result;

SUSPEND;
END


Via my Delphi+dbExpress program (and also EMS IB/FB Manager) this
procedure gives
0.666666686534882

but I think it should rather give
0,666666666666667

isql gives
0.66666669

so it seems to be client issue. How big is float in Firebird?

Any recommendations how to avoid this incorrect rounding in dbExpress?


thanks!

Aivar