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