Re: how to suppress carefully a recursive tree

From: -CELKO- <jcelko212@xxxxxxxxxxxxx>
Date: Sat, 26 Jan 2008 00:11:57 -0800 (PST)

Get a copy of TREES & HIERARCHIES IN SQL and look up the Nested Sets
model. You can Google it for the basic idea.

You would put the nodes into one table and the structure into a second
table with (lft, rgt) as its key, then reference the node for that
position.

Jan, sorry to be late, but I was out of town this week :)
.

References:
- how to suppress carefully a recursive tree
  - From: fj

Prev by Date: Re: Join types
Next by Date: tv ad
Previous by thread: Re: how to suppress carefully a recursive tree
Next by thread: Useful Unicode
Index(es):
- Date
- Thread

Relevant Pages

Re: Trying to implent (Joe Celkos) Nested Sets, but need more data columns
... Nested sets are just one of many ways to model such ... >things in SQL. ... If anyone using nonrelational features needs help, ... It's possible to model hierarchies to obtain all the benefits of your ...
(microsoft.public.sqlserver.programming)
Re: Need Help Spanning A Category Tree
... Get a copy of TREES & HIERARCHIES IN SQL and about the Nested Sets ... It will run much better than this adjacency list model. ...
(comp.databases.ms-sqlserver)
Re: SELECT & recursion
... Get a copy of TREES & HIERARCHIES IN SQL for single table, ... models that use only SQL-92. ... In particular look at the nested sets ...
(comp.databases)
Re: different kind of calculations
... Get a copy of TREES & HIERARCHIES IN SQL and look at the Nested Sets ...
(comp.databases.olap)
Re: Single query to find multi-level relationships?
... get a copy of TREES & HIERARCHIES IN SQL and look at the nested sets ...
(comp.databases)