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