Subject Re: [firebird-support] Floating point value issue
Author Dimitry Sibiryakov
On 7 Apr 2005 at 23:23, Craig wrote:

>I inherited an SQL table which uses a floating point value as the ID,

You mean MS SQL, don't you?

>and i converted this table into a Firebird Table, maintaining the
>floating point type for the ID, however I have noticed the floating
>point values are not the same when i view these values, for example -

I think, you made two mistakes: kept floating type for PK and
declared it as 'FLOAT' which has only 7 digits precision instead of

>Are there issues with Floats in Firebird { using version 1.5.2 as an
>Embedded Server in this instance, but also a Classic Server }

Only common issue - float is unprecise and must not be used in PK.

Replace it with NUMERIC. If your example was typical, you can use
SY, Dimitry Sibiryakov.