Re: Closing Gaps in Celko trees - Mailing list pgsql-general

>> 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);