CREATE TABLE test ( id integer, data jsonb ) Partition by range (( data #>> '{info,time}' ));
CREATE TABLE test_part1 PARTITION OF test
FOR VALUES FROM ('30000') TO ('40000');
INSERT INTO test VALUES (1,'{"info":[{"time":39814.0,"value":2}, {"time":39815.0,"value":3}]}');
Is there a way to do this ? or is it in development?
Thanks!
Marc