postgresql7.1
select count(*) as number_elements
from rel_segment_party_map map
where acs_permission__permission_p(map.party_id, :user_id, 'read')
and map.segment_id = :segment_id
select s.segment_id, s.segment_name, s.group_id, acs_object__name(s.group_id) as group_name,
s.rel_type, acs_object_type__pretty_name(r.rel_type) as rel_type_pretty_name,
acs_rel_type__role_pretty_plural(r.role_two) as role_pretty_plural
from rel_segments s, acs_rel_types r
where s.segment_id = :segment_id
and s.rel_type = r.rel_type