On 1/19/24 20:08, Andreas Joseph Krogh wrote:
I have order-lines with start-end like this:
|start_date DATE NOT NULL, end_date DATE, drange daterange NOT NULL
GENERATED ALWAYS AS (daterange(start_date, end_date, '[)')) STORED|
and have an index on |using gist(drange)|
I want to list all order-lines which does not have end-date set in the
past, but want to show lines with start-dates in future.
This seems to do what I want:
|NOT (drange << daterange(CURRENT_DATE, NULL, '[)'))|
But this doesn't use the index.
Any idea how to write a query so it uses the index on |drange|?
Without the full query and the EXPLAIN output I don't see that there is
much that can be offered in way of an answer.
Thanks.
--
*Andreas Joseph Krogh*
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@xxxxxxxxxx <mailto:andreas@xxxxxxxxxx>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
