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