On Wed, 18 Feb 2004, Josh Berkus wrote:
> The planner can't, or doesn't want to, use an index on (event_date,
> (event_date + duration)) where the first column is an ascending sort and the
> second a descending sort. So I've coded a workaround that's quite
> inelegant but does get the correct results in 0.3 seconds (as opposed to the
> 2.2 seconds taken by the example plan).
Can you give more information? I know that I'm not exactly certain what
the situation is from the above and the original query/explain piece.