John,

Yes please. Im sure it would be a good starting point.


Thanks alot
Jem Rayfield
Technical Consultant
Deutsche Bank [/]
CIB - IT Infrastructure
Corporate and Investment Bank (CIB)
London
t: +44(20)754-51943



John Croft
<jcroft@compsolve To: ib-support@yahoogroups.com
.com> cc:
Subject: Re: [ib-support] Tree as adjaceny List conversion to nested set.
06/02/2003 14:47
Please respond to
ib-support






I have a stored procedure that will traverse the tree and you should be
able to modify it to write the nested set records. Let me know if you
want it.
John Croft

Jem Rayfield wrote:

>Hi,
>
>I have a tree structure stored as an adjacency list
>
>create table tree (
> id integer,
> pid integer,
> name varchar( 10 )
>)
>
>
>I want to convert this Tree into a nested set using the following
>data structure.
>
>create table nested_set (
> name varchar( 10 ),
> left integer,
> right integer
>)
>
>
>Has anyone got a URL/example stored-procedure for this type of
>conversion?
>
>Thanks for any pointers.
>
>Jem Rayfield
>Technical Consultant
>Deutsche Bank [/]
>CIB - IT Infrastructure
>Corporate and Investment Bank (CIB)
>London
>t: +44(20)754-51943
>
>
>
>--
>
>This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/







--

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.