Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Location
    Deutschland
    Posts
    10

    Question Unanswered: possible to move nodes in Nested Set Model?

    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

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

  3. #3
    Join Date
    Jun 2004
    Location
    Deutschland
    Posts
    10
    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

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Isn't a move just a shorthand for a delete and an insert?

  5. #5
    Join Date
    Jun 2004
    Location
    Deutschland
    Posts
    10
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •