Aage Johansen wrote: > First, thanks to Paul for checking my suggestions. > Actually, I may have misremembered: I thought there might be pitfalls > regarding the sign of the result.
There are. Or rather, there is one: 0x80000000 - 0xFFFFFFFF map to negative INTEGER values, whereas 0x080000000 - 0x0FFFFFFFF map to positive BIGINTs. But I see Helen has taken care of that in her latest commit. > As for BETWEEN and the others: maybe precedence is totally irrelevant > for "comparison predicates". I just mentioned it since "comparison > operators" have defined precedence. According to IBPhoenix's Using Firebird and Helen's Firebird Book, BETWEEN...AND, LIKE, CONTAINING and STARTING [WITH] all have precedence 9 (lowest) among the comparison operators. I assume that the same is true for SIMILAR TO. > I've spent most of Easter in hospital, and haven't really been keen on > doing testing. Sorry about that. Hope you're doing alright now! Cheers, Paul Vinkenoog ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 _______________________________________________ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs