postgresql7.1
select p.public_p,
p.pres_title as presentation_title,
acs_permission__permission_p(:pres_item_id, :user_id, 'wp_admin_presentation') as admin_p,
acs_permission__permission_p(:pres_item_id, :user_id, 'wp_delete_presentation') as delete_p,
ao.creation_user
from cr_wp_presentations p,
cr_items i,
acs_objects ao
where i.item_id = :pres_item_id
and i.live_revision = p.presentation_id
and ao.object_id = :pres_item_id
select first_names || ' ' || last_name as full_name,
person_id,
acs_permission__permission_p(:pres_item_id, person_id, 'wp_view_presentation') as view_p,
acs_permission__permission_p(:pres_item_id, person_id, 'wp_edit_presentation') as edit_p,
acs_permission__permission_p(:pres_item_id, person_id, 'wp_admin_presentation') as admin_p
from persons
where acs_permission__permission_p(:pres_item_id, person_id,
'wp_view_presentation') = 'f'
or acs_permission__permission_p(:pres_item_id, person_id, 'wp_edit_presentation') = 't'
or acs_permission__permission_p(:pres_item_id, person_id, 'wp_admin_presentation') = 't'