-- -- wp_slide__get_preamble/1 -- create or replace function wp_slide__get_preamble( integer ) returns text as $$ declare p_slide_item_id alias for $1; begin return content from cr_revisions, cr_items where cr_items.content_type = 'cr_wp_slide_preamble' and cr_items.parent_id = p_slide_item_id and cr_revisions.revision_id = cr_items.live_revision; end;$$ language plpgsql;