v.19.3New Features
Implemented NOT BETWEEN Comparison Operator
Implemented NOT BETWEEN comparison operator. #4228 (Dmitry Naumov)Why it matters
This feature addresses the need to efficiently filter data where values lie outside a given range, improving query expressiveness and readability by providing a direct operator instead of negatingBETWEEN conditions.How to use it
Use theNOT BETWEEN operator in WHERE clauses or conditional expressions as follows:SELECT * FROM table WHERE column NOT BETWEEN lower_bound AND upper_bound;