Re: Creating a Hierarchical Structure

Thanks, for your answer

Unfortunetly this can't be done in this case. As their are no "positions" at all. The only thing is that it has to create something like a pyramid. Is there a way to do this ?

thanks,

Fernando

"David Cressey" <david_at_dcressey.com> wrote in message news:<g0ul7.437$Iw2.27054_at_petpeeve.ziplink.net>...
> One technique for reducing the number of inserts is to have a hierarchy for
> roles of people, not people themselves.
> One of the columns in this hierarchy table is Person_Id which is a foreign
> key. When a person leaves a role, the Person_ID is set to null, indicating
> the role is vacant. When a new person is named to the role, Person_ID is
> updated again.
>
> The other columns of the hierarchy table follow the nested set concept.
>
> Now, the only time we have to re do the nested sets themselves is when a
> new role is created. This is presumably less often than the reassignment
> of persons.
Received on Thu Sep 06 2001 - 08:27:23 CDT