Re: how to suppress carefully a recursive tree

From: -CELKO- <>
Date: Sat, 26 Jan 2008 00:11:57 -0800 (PST)
Message-ID: <>

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