> -----Original Message-----
> From: Jim Starkey [mailto:jas@...]
> Sent: Viernes 24 de Mayo de 2002 12:48
> To: IB-Architect@yahoogroups.com; IB-Architect@yahoogroups.com
>
> 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.

C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://www.cvalde.com - http://www.firebirdSQL.org
Stop Spam - Save Joey McNicol
http://t3-v-mcnicol.ilaw.com.au/