R
R
Rigorbb2016-05-19 17:11:31
PostgreSQL
Rigorbb, 2016-05-19 17:11:31

How to create an index on timestemp in jsonb?

Is it possible in postgresql to add an index to one of its timestamp keys on a jsonb field containing a large json? Or the index in any case, how not to be perverted, will be textual and will not do the weather?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2016-05-19
@Rigorbb

Technically, this will be a functional index, but easily
In order for it to be used, you will need to cast to the timestamp in the request as well.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question