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
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.
>
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