postgresql7.1 select note_id, owner_id, title, 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 acs_permission__permission_p(note_id, :user_id, 'read') = 't' order by creation_date