postgresql7.1
select g.workflow_key, wf.description as workflow_description, pretty_name as workflow_name
from glossariesx g, wf_workflows wf, acs_object_types ot
where g.workflow_key = wf.workflow_key
and wf.workflow_key = ot.object_type
and g.item_id = :item_id
and g.revision_id = content_item__get_live_revision(:item_id);
select case when count(*) = 0 then 0 else 1 end
from glossary_termsx
where ( acs_permission__permission_p(item_id, :user_id, 'glossary_term_modify') = 't' or acs_permission__permission_p(item_id, :user_id, 'glossary_term_illustration_add') = 't' or acs_permission__permission_p(item_id, :user_id, 'glossary_term_illustration_modify') = 't')
select g.title, i.name, g.description, g.owner_id, i.publish_status,
case acs_permission__permission_p(i.item_id, :user_id, 'glossary_admin')
when 't' then 1
when 'f' then 0
end as glossary_admin_p
from glossariesx g, cr_items i
where i.item_id = :item_id
and i.publish_status = 'live'
and i.content_type = 'glossary'
and i.live_revision = g.revision_id
select acs_object_id_seq.nextval
select glossary__new (
:owner_id,
:name,
:title,
:description,
:package_id,
:user_id,
:peeraddr,
:context_id,
:is_live,
'glossary_admin'
);