Re: Recursive join - blind alley?

From: --CELKO-- <joe.celko_at_northface.edu>
Date: 4 Jan 2004 11:03:33 -0800
Message-ID: <a264e7ea.0401041103.6767d918_at_posting.google.com>


>> 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

Original text of this message