postgresql7.2 select content_revision__delete(:revision_id); select count(*) from cr_revisions where item_id = ( select item_id from cr_revisions where revision_id = :revision_id ) select content_item__set_live_revision (:revision_id, 'live') select content_item__unset_live_revision (item_id) from cr_revisions where revision_id = :revision_id select x.item_id, x.revision_id, x.name, x.title, x.description, p.first_names, p.last_name, to_char(x.last_modified,'HH:MI AM MM/DD/YYYY') as creation_date, l.live_revision_id from ${table_name}x x, persons p, (select content_item__get_live_revision(:item_id) as live_revision_id) l where x.creation_user = p.person_id and x.item_id = :item_id order by x.last_modified desc; select content_revision__copy(:revision_id, null, null, :creation_user_id, :creation_ip)