On Tue, Apr 11, 2006 at 02:34:22 -0700,
Timo Tuomi <[EMAIL PROTECTED]> 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 "s
I'm stucked..
Say a car travels from X to Y then from Y to Z (and then from Z back
to X but that's not relevant here).
In the table below are the timestamps for each point in various
dates. The complete trip X-Y-Z-X is in the table but each leg on a
separate row.
I'd need to get the time interva
