Re: Implementing an ordered tree

Karoly Szantai wrote:
> Hello,
>
> I have a Category entity. Each Category has zero or more 
> subcategories, which are ordered. There is a root Category (called 
> main category) which has no parent.
There's a guy named Joe Celko who has a bunch of suggestions on how to 
do trees in relational databases.  You may want to take a look at his 
algorithms.

Other than that, is the ordering a user-ordering or a tree-ordering?  
That is, is the order for organizing the display or some characteristic 
of the tree?

-arturo