Re: [SQL] Recursive temporal query

2012-10-19 Thread Liam Caffrey
With source data... On 19 October 2012 16:40, Liam Caffrey wrote: > Hi, > > I am trying to run a recursive cte query on temporal data. > I attach the starting set (temp_station) and the solution set > (temp_solution) > > A user visits many stations in random order. > They can enter a station man

Re: [SQL] Recursive temporal query

2012-10-19 Thread Liam Caffrey
Hi, I am trying to run a recursive cte query on temporal data. I attach the starting set (temp_station) and the solution set (temp_solution) A user visits many stations in random order. They can enter a station many times but they only exit once. After they enter a station X, they can enter other