--
-- 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;