Re: how to suppress carefully a recursive tree
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 :) Received on Sat Jan 26 2008 - 09:11:57 CET