postgresql7.1 declare v_revision_id integer; select content_item.set_live_revision(:revision_id); select id into v_revision_id from cr_wp_presentations_aud where presentation_id = :revision_id; select content_item.set_live_revision(:v_revision_id); select id into v_revision_id from cr_wp_presentations_back where presentation_id = :revision_id; select content_item.set_live_revision(:v_revision_id);