How to create an index on the timestemp in jsonb?

Question

How to create an index on the timestemp in jsonb?

Is it possible in postgresql jsonb field for containing a large JSON, add an index on one of its keev timestamp? Or index in any case, don't go Berko will be text and will not make the weather?

PostgreSQL

alejandrin_Wilderman asked July 9th 19 at 12:59

Related questions

More answers about "How to create an index on the timestemp in jsonb?"

1 answer

Ignacio_Romaguera answered on · Accepted Answer · 2019-07-09T13:01:58.501Z

Ignacio_Romaguera answered on July 9th 19 at 13:01

Solution

Technically, it would be a functional index, but it is easily

create index on tablename using btree((jsonb->ts)::timestamp);

To use, you will need to request to carry out the conversion to timestamp.