-- -- wp_presentation__set_live_revision/1 -- create or replace function wp_presentation__set_live_revision( integer ) returns int4 as $$ declare p_revision_id alias for $1; v_revision_id integer; begin perform content_item__set_live_revision(p_revision_id); select id into v_revision_id from cr_wp_presentations_aud where presentation_id = p_revision_id; perform content_item__set_live_revision(v_revision_id); select id into v_revision_id from cr_wp_presentations_back where presentation_id = p_revision_id; perform content_item__set_live_revision(v_revision_id); return 0; end;$$ language plpgsql;