Re: Modelling hierarchy in the relational database

> Another way of representing trees is to show them as nested sets.
> Since SQL is a set oriented language, this is a better model than the
> usual adjacency list approach you see in most text books. Let us

I must have seen this discussion at least a dozen times in this newsgroup. I like your response. I like it a lot.
And it gets better with age.

But wouldn't the entire newsgroup be better off if we had an associated FAQ repository? Then we could just refer
the next person who enters the newsgroup and asks about hierarchies to the FAQ.

--
Regards,
    David Cressey
    www.dcressey.com