Re: Daterange question

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

-- 
Adrian Klaver
adrian.klaver@aklaver.com