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?
July 9th 19 at 12:59
1 answer
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.

Find more questions by tags PostgreSQL