Re: Nested Sets Insertion

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Mon, 12 May 2003 16:53:10 -0700
Message-ID: <VzWva.18$tA3.243@news.oracle.com>

"Enu" <ewiner_at_adelphia.net> wrote in message news:7f10cvkbpair78e2c4dgdpg385udho9a94_at_4ax.com...
> I'm not familiar with "materialize path". Is that where you just have
> a column that says something like "1.2.1.5.2" to denote the second
> child of the fifth child of the first child of the second child of the
> first item?

Yes. Check it out:

http://www.dbazine.com/tropashko4.html

He describes a labeling schema, which is very similar to Celko nested sets, except that is persistent. (In persistent labeling every tree node gets a permanent "hierarchy address"). However, there is some procedural code there, for example, functions translating number codings into materialized path and vice versa. Could you program user-defined functions in MySQL? Received on Mon May 12 2003 - 18:53:10 CDT