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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to