Re: Recursive join - blind alley?

>> I want many trees in this forest. More than one root. How's that
done? <<

You cannot, by definition, have more than one root in a tree. You can have forest, tho:

CREATE TABLE Forest
(tree_id CHAR(5) NOT NULL,
 node_id CHAR(5) NOT NULL REFERENCES Nodes(node_id),  lft INTEGER NOT NULL UNIQUE,
 rgt INTEGER NOT NULL UNIQUE,
 ..);

Now you can set up rules about nodes and trees. Received on Sun Jan 04 2004 - 20:03:33 CET