On Tue, Apr 11, 2006 at 02:34:22 -0700,
Timo Tuomi <ttuomi(at)gmail(dot)com> wrote:
>
> I'd need to get the time interval X-Y-Z on each date but I cannot rely
> on the date (can't make any joins based on the date part of
> timestamps). Instead I'd need to find out X-Y and Y-Z pairs with a
> minimal "stop" -time at Y and calculate total travel time for those.
If possible you should change your design, so that you can identify a route.