Re: Nested Sets Insertion
Date: Mon, 12 May 2003 16:53:10 -0700
Message-ID: <VzWva.18$tA3.243_at_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 Tue May 13 2003 - 01:53:10 CEST