> I have one question because I'm not clear about
> something with your
> implementation (a good one too by the looks of it -- thanks
> for sharing
> this information); if I start my query from an item at level
> 5, will the
> level be reflected as such, or will it dynamically start
First off, props for this go to Chris Wenham from his Live Journal post
http://www.livejournal.com/users/terrulen/6008.html. He's happy for me
to pass on the secrets :)
Standard disclaimer applies but it worked well for me with no mods to
our table structure although I had to adjust the function
I'll start by admitting that I've not looked at it myself yet but I'm
just wondering if any others have looked at this yet. A while ago we
migrated a complex web-app from Oracle to postgres. It went very well
when it came to replace 'connect by prior'. Because we were time poor
we couldn't spend
