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(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
> www.visena.com <https://www.visena.com>
> <https://www.visena.com>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com