Daterange question - Mailing list pgsql-general

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@visena.com

www.visena.com