Daterange question

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

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?

 

Thanks.

 

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@xxxxxxxxxx

www.visena.com