postgresql7.2 select n.name, n.object_id, n.name as rawname, tree_level(n2.tree_sortkey) as level from site_nodes n, site_nodes n2 where n.name is not null and n.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey) and n.object_id=405