Re: O'Reilly interview with Date

Kenneth Downs wrote:

>>b) a single interval column? Then you have a problem joining to the
>>start date of the interval. The interval is atomic, but you could have a
>>start() function that picks out the start of the interval. Even so, this
>>ceases to be a standard join.

What I'm saying is if you want separate joins both to the interval *and* to the start or end dates.

For example, thinking of booking holidays or something: there might be a supplement to the price if the duration spans a bank holiday, say, so you'd need a "join" to the interval.

But also there might be a reduction to the price if the holiday starts on some dates specified in another table, so you'd want a join to the start date as well.

Then you could have either one of the joins as standard in your setup, but not both.

Paul. Received on Sun Aug 14 2005 - 10:34:25 CEST