Re: Closing Gaps in Celko trees

>> Im trying to convert one of the functions the Celko wrote for closing gaps
in lft,rgt tree type. <<

I have a better way now:

CREATE VIEW LftRgt (i)
AS SELECT lft FROM Tree
UNION ALL
SELECT rgt FROM Tree;

UPDATE Tree
SET lft = (SELECT COUNT(*)
FROM LftRgt
WHERE i <= lft),
rgt = (SELECT COUNT(*)
FROM LftRgt
WHERE i <= rgt);