-- -- content_item__get_publish_date/2 -- create or replace function content_item__get_publish_date( integer, boolean ) returns timestamptz as $$ declare get_publish_date__item_id alias for $1; get_publish_date__is_live alias for $2; -- default 'f' v_revision_id cr_revisions.revision_id%TYPE; v_publish_date cr_revisions.publish_date%TYPE; begin if get_publish_date__is_live then select publish_date into v_publish_date from cr_revisions r, cr_items i where i.item_id = get_publish_date__item_id and r.revision_id = i.live_revision; else select publish_date into v_publish_date from cr_revisions r, cr_items i where i.item_id = get_publish_date__item_id and r.revision_id = i.latest_revision; end if; return v_publish_date; end;$$ language plpgsql;