Hello. Does MemSQL have any plans to develop a “range type”? For example, postgresql has a range type even if the syntax is a bit obtuse.
As far as I can tell in order to support range functionality something like the following would have to be done:
CREATE TABLE t ( min_value INT, max_value INT ); INSERT INTO t (min_value, max_value) VALUES (20, 30); SELECT * FROM t WHERE 23 >= t.min_value AND 23 < t.max_value;
It would be really nice to have something like as follows:
CREATE TABLE t ( value INT_RANGE ); INSERT INTO t (value) VALUES ('[20, 30)'); SELECT * FROM t WHERE 23 IN t.value