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

Reply via email to