Re: how to suppress carefully a recursive tree

From: -CELKO- <jcelko212_at_earthlink.net>
Date: Sat, 26 Jan 2008 00:11:57 -0800 (PST)
Message-ID: <25816c17-7d48-42d7-904f-a9260a1af717_at_v67g2000hse.googlegroups.com>


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 :) Received on Sat Jan 26 2008 - 09:11:57 CET

Original text of this message