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