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