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
|