> The actual test I'm doing is something like: > WHERE ?1 >= (base + begin) AND ?1 < (base + end)
> where ?1, base, begin, and end are all 64-bit addresses.
This is a test with a well known optimization for unsigned values:
WHERE (?1 - base - begin) < end
To make the < test unsigned in SQL use
WHERE ((?1 - base - begin) + 9223372036854775808)) < (end +
9223372036854775808)
This is with all values stored "raw," i.e., without offset.
e
