On 06/06/18 13:12, Mark Rotteveel wrote:
BTW: earlier you complained about it being fractional, and now you're
complaining about the precision of those fractions not being precise
enough?
I don't think I understand what you're arguing for and what the problem
is, unless you are arguing that the range end should be exclusive, so
[start, end), which means that "end" is the same value as "start" of the
next one, eg
While internally time is limited by the precision of 100 microseconds.
externally this is not the case. So the internal 'end timestamp' can't
be used externally without some care. But I don't see why 'between' is
so important here. In many cases you are ONLY worried about the offset
for the timestamp so an internal GT and LT is much more logical ... AND
works better when simply using the rules direct ... no need to populate
vast tables of transitions ... This is useful where you have more than
one set of rules so you can select the right version when processing and
upgrade to a new version ... If you update the table of transitions
before establishing if any data needs amending you don't know what the
original data was ...
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
