Re: Nested set model with large gaps and spreads in the numbering
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 17 Sep 2002 06:39:05 -0700
Message-ID: <c0d87ec0.0209170539.7ce7653a_at_posting.google.com>
Date: 17 Sep 2002 06:39:05 -0700
Message-ID: <c0d87ec0.0209170539.7ce7653a_at_posting.google.com>
>> For some reason, what you are trying to do reminds me of the
process of
defragmenting a disk. <<
Good thought!
Richard Romley sent me a recursive UDF that computes the new left value for a node. It can be put into one statement then used in UPDATE Tree
SET lft = ShiftLeft(left),
rgt = ShiftLeft(left) + (rgt-lft);
Very neat. I have to go out of town, but I will post it when I get back. Received on Tue Sep 17 2002 - 15:39:05 CEST