Re: Having difficulties partitionning with jsonb

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Having difficulties partitionning with jsonb
Дата
Msg-id CAMkU=1z0S22WRA0O2qM49dAn1ZZO_NbSM5MpBLF6E=v4Z-vyKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Having difficulties partitionning with jsonb  (ouellet marc-andre <Ouellet_MarcAndre@hotmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Aug 22, 2019 at 5:41 PM ouellet marc-andre <Ouellet_MarcAndre@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 ('30000') TO ('40000');

INSERT INTO test VALUES (1,'{"info":[{"time":39814.0,"value":2}, {"time":39815.0,"value":3}]}');


The partitioning expression yields NULL on the given input.

select '{"info":[{"time":39814.0,"value":2}, {"time":39815.0,"value":3}]}'::jsonb #>> '{info,time}';
 ?column?
----------
 (null)
(1 row)

Maybe you meant '{info,0,time}', or maybe you meant '{info,1,time}'.  Or maybe you meant something else. You will have to explain yourself.

Cheers,

Jeff

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: A question aboout postgresql-server-dev versions
Следующее
От: stan
Дата:
Сообщение: What is the difference between creating a type, and a domain ?