postgresql7.1 select t2.object_type as ancestor_rel_type from acs_object_types t1, acs_object_types t2 where t1.object_type = :add_with_rel_type and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey) and t2.supertype = 'relationship'