Re: Forcing filter/join order?

Tom,

> Uh, why do you need the child table?

Because there's linked information which needs to be kept by day for multi-day
events.   Also, it makes calendar reports easier, where one wants each day of
a multi-day event to appear on each day of the calendar.

>Seems like the correct incantation
> given an assumption about maximum duration is
>
> event_date <= 'end-date' AND (event_date + duration) >= 'start-date'
> AND event_date >= 'start-date' - 'max-duration'

Hmmmm ... so the same as what I have, only with the extra condition for
event_date+duration and without the IN clause.   I'll try it, thanks!

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco