Subject RE: [IB-Architect] Bi-Directional cursor support WAS: Re: triggers + plans
Author Claudio Valderrama C.
> -----Original Message-----
> From: Jim Starkey [mailto:jas@...]
> Sent: Viernes 24 de Mayo de 2002 12:48
> To:;
> Index walking in Interbase/Firebird is always problematic due
> to an inherent inprecision of the indexes (all numbers and dates
> are converted to double precision floating with inevitable
> roundoff problems). The index scan code must revalidate a
> candidate record to compensate for record generation issues,
> this isn't a problem. But it is a nasty problem for index
> walking, expecting to get a strict ordering.

And what's the reason that indices need numbers and dates transmogrified
into floating point values? Isn't there any alternative approach? Two very
close timestamps in a column could be different yet for the index they could
become indistinguishable.

Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente -
Stop Spam - Save Joey McNicol