On Tuesday, February 1, 2022, Дмитрий Воронин <
carriingfate92@yandex.ru> wrote:
...
"dates": ["2019-10-02", "2018-02-03"]
...
So, I want to SELECT all docids, which dates in range:
So, searching on dates field will be often and I want speed up by indexing but I don't known how.
Create a generated column of type daterange and populate that on insert/update. Index that column. Write queries against that column. (Not tested, but in short get rid of the json pseudo daterange array implementation and use the real SQL daterange type)
David J.