postgresql7.1
select
rm.room_id, rm.pretty_name, rm.description, rm.active_p, rm.archive_p
from
chat_rooms rm,
(select distinct orig_object_id
from acs_permission.permission_p_recursive_array(array(
select object_id from acs_objects where package_id = :package_id
), :user_id, 'chat_read')
) p
where p.orig_object_id = rm.room_id
order by rm.pretty_name