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 n2.tree_sortkey <= n1.tree_sortkey and n1.tree_sortkey like (n2.tree_sortkey || '%') order by level desc