Check this url..
http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html
nright and nleft are called lft and rgt in that document.
It's a common thing that the tree gets screwed. It's mostly when
somebody moves an tree node and don't let the page finish the reorder of
the tree before moving another node.
/ Daniel
Vorn wrote:
Something gone screwy with our tree and I'm trying to do a bit of
diagnostic work...
I'm a bit confused - can someone explain to me how the nLeft and
nRight columns work in nested_tree_objects?
