R: [GENERAL] Special index for "like"-based query

Поиск
Список
Период
Сортировка
От Job
Тема R: [GENERAL] Special index for "like"-based query
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC1A8@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответ на Re: [GENERAL] Special index for "like"-based query  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general
Dear Alban,

Regarding:

>>... AND timestamp BETWEEN '2016-12-27 00:00:00'::timestamp with time zone AND '2016-12-30 23:59:59'::timestamp with
timezone ...  

I think it is a very good approach, and i would like to try.
My table has got two different field for "starting" and "ending" timestamp values.

Shall i create an index together with the two field (starting and ending) with the "tsrange" statement?

Thank you again!

/F

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: [GENERAL] Special index for "like"-based query
Следующее
От: Job
Дата:
Сообщение: R: [GENERAL] Special index for "like"-based query