--
-- wp_presentation__get_ad_revision/1
--
create or replace function wp_presentation__get_ad_revision(
  integer
) returns text as $$

declare
    p_pres_revision_id  alias for $1;
begin
  return r.content
  from cr_revisions r, cr_wp_presentations_aud pa
  where pa.presentation_id = p_pres_revision_id
    and r.revision_id = pa.id;
end;$$ language plpgsql;