Re: SOLVED: Emulating 'connect by prior' using stored proc

[sNip]
> It's the same in this case. The tree building stuff only ever looks down
> so the level returned in the query results will start at 1 no matter
> where you enter your tree. In our case we could enter the tree at
> 'node' 100 and get the tree below that but the function will start at 1
> because we only interested in the data below not the entry point and not
> where in the tree we entered.

Thanks. That's excellent news! =)

> As in the solution if you really want to start it at 5 then set that as
> the value of your second parameter.

Interesting. Although I don't have an immediate need for this, I'm
sure it could be useful when storing the results of multiple queries of this
nature in a temporary table.

--
Randolf Richardson - rr(at)8x(dot)ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.