postgresql7.1 select site_node__url(n2.node_id) as url, n2.object_id, acs_object__name(n2.object_id) as object_name, tree_level(n2.tree_sortkey) as level from (select * from site_nodes where node_id = :node_id) n1, site_nodes n2 where n1.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey) and tree_ancestor_p(n2.tree_sortkey, n1.tree_sortkey) order by level asc