possible to move nodes in Nested Set Model?

deviant69 · #1 (**permalink**) 06-25-04, 10:37

Hi,

i work with the Nested Set Model and my question is, does anybody know if it is possible to move nodes inside this Nested Set Model, and if it is possible, if there is an example.

thanks in advice
deviant69

Pat Phelan · #2 (**permalink**) 06-25-04, 11:34

Yes. Joe Celko published an example in his SQL For Smarties book, and I think it might be in one of his online columns too.

-PatP

deviant69 · #3 (**permalink**) 06-25-04, 11:44

i tried to find some example in the internet, but there isn't. i found lots of examples for convertig, inserting and deleting, but no example for moving.

but thanks for the advice, i will look out for the book.
deviant69

andrewst · #4 (**permalink**) 06-28-04, 07:44

Isn't a move just a shorthand for a delete and an insert?

deviant69 · #5 (**permalink**) 06-28-04, 08:23

you can delete and insert, but that would mean that u have to store the data somewhere. sure, i think there is a possibility to handle it that way, but finally i found another way to handle the movements.

deviant69