-- -- content_item__get_best_revision/1 -- create or replace function content_item__get_best_revision( integer ) returns int4 as $$ declare get_best_revision__item_id alias for $1; v_revision_id cr_revisions.revision_id%TYPE; begin select coalesce(live_revision, latest_revision ) into v_revision_id from cr_items where item_id = get_best_revision__item_id; return v_revision_id; end;$$ language plpgsql;