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
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

--
Adrian Klaver
adrian.kla...@aklaver.com



Reply via email to