Re: SQL99 Hierarchical queries

Mike,

> I'm curious what kind of performance differences there would be over
> using something like the nested-set model?
>
> Would this be faster, or slower?

The answer is "yes".    ;-)

Which tree structures you use depends on what you're trying to accomplish and 
what your use case is.   There are some structures (for example, heirarchical 
org charts) for which nested sets can't be beat.   There are plenty of 
reasons to implement other tree structures, such as graphs, cycles, and 
delimited lists depending on what you're trying to depict.   

What WITH is going to "replace", if anything, is the simple adjacency list 
structure.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco