Having difficulties partitionning with jsonb

From: ouellet marc-andre <Ouellet_MarcAndre(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Having difficulties partitionning with jsonb
Date: 2019-08-22 21:40:54
Message-ID: BY5PR11MB4008653FD24DE4348BC3E3109FA50@BY5PR11MB4008.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bikram MAJUMDAR 2019-08-22 21:50:08 RE: Question on pgwatch
Previous Message Igal @ Lucee.org 2019-08-22 20:55:33 Re: How to install Postgres 12 beta with YUM