postgresql7.1
select g.title as glossary_title, g.revision_id
from glossariesx g
where g.item_id = :item_id
and g.revision_id = content_item__get_latest_revision(:item_id)
update acs_objects
set last_modified = current_timestamp,
modifying_user = :user_id,
modifying_ip = :peeraddr
where object_id = :item_id