Re: Having difficulties partitionning with jsonb

2019-08-25 Thread Jeff Janes
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

Having difficulties partitionning with jsonb

2019-08-22 Thread ouellet marc-andre
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