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