postgresql7.1 select n.note_id, n.title, n.body, case when acs_permission__permission_p(note_id,:user_id,'write')='t' then 1 else 0 end as write_p, case when acs_permission__permission_p(note_id,:user_id,'admin')='t' then 1 else 0 end as admin_p, case when acs_permission__permission_p(note_id,:user_id,'delete')='t' then 1 else 0 end as delete_p from notes n, acs_objects o where n.note_id = o.object_id and o.context_id = :package_id and exists (select 1 from acs_object_party_privilege_map where object_id = note_id and party_id = :user_id and privilege = 'read') order by creation_date