Re: Daterange question

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: Daterange question
Дата
Msg-id VisenaEmail.4.77e0ca2a10ddb492.18d257d4a76@origo-test01.app.internal.visena.net
обсуждение исходный текст
Ответ на Re: Daterange question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
På lørdag 20. januar 2024 kl. 06:35:07, skrev Tom Lane <tgl@sss.pgh.pa.us>:
[…]
Well, we can definitively state that the NOT makes this unindexable.
You need a WHERE clause that looks like
indexed-column indexable-operator pseudo-constant
which this isn't, nor does << have a negator operator that could
allow the NOT to be simplified out.

Wouldn't
drange && daterange(CURRENT_DATE, NULL, '[)')
serve the purpose?  That should be indexable.

regards, tom lane

Yes it will, thanks.

 

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Daterange question
Следующее
От: Chris Angelico
Дата:
Сообщение: Logical replication claims to work, not working - new tables