On Thu, Aug 22, 2019 at 5:41 PM ouellet marc-andre <
ouellet_marcan...@hotmail.com> wrote:
> CREATE TABLE test ( id integer, data jsonb ) Partition by range (( data
> #>> '{info,time}' ));
>
> CREATE TABLE test_part1 PARTITION OF test
> FOR VALUES FROM ('3') TO ('4');
>
> INSERT INTO
CREATE TABLE test ( id integer, data jsonb ) Partition by range (( data #>>
'{info,time}' ));
CREATE TABLE test_part1 PARTITION OF test
FOR VALUES FROM ('3') TO ('4');
INSERT INTO test VALUES (1,'{"info":[{"time":39814.0,"value":2},
{"time":39815.0,"value":3}]}');
Is there a way