Source of list1a/index-postgresql.xql
<?xml version="1.0"?>
<queryset>
<rdbms><type>postgresql</type><version>7.1</version></rdbms>
<fullquery name="template_demo_notes">
<querytext>
select
n.template_demo_note_id,
n.title
from template_demo_notes n, acs_objects o
where n.template_demo_note_id = o.object_id
and acs_permission__permission_p(template_demo_note_id, :user_id, 'read')
</querytext>
</fullquery>
</queryset>