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