Hi Adam, You can use a schema like this:
CREATE TABLE NODE ( NODE_ID INTEGER NOT NULL, PARENT_ID INTEGER NOT NULL, NAME VARCHAR (50), PRIMARY KEY (NODE_ID)); It isn't difficult to extract a tree object model from this schema. ~ Leon ----- Original Message ----- From: "Adam Sherman" <[EMAIL PROTECTED]> To: "Turbine Users" <[EMAIL PROTECTED]> Sent: Wednesday, October 03, 2001 2:30 PM Subject: Tree Structures > Does anybody know of/have a chunk of code to store tree structuresin a > RDBMS? I'm looking for the most efficient way to do this. > > I think it would be a valuable addition to Turbine, since Trees are > quite common... > > Thanks, > > A. > > -- > Adam Sherman > President & Technology Architect > Tritus Consultant Group Inc. > +1.613.255.5164 > http://www.tritus.ca > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
