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/
>