--
-- content_item__get_live_revision/1
--
create or replace function content_item__get_live_revision(
  integer
) returns int4 as $$

declare
  get_live_revision__item_id                alias for $1;  
  v_revision_id                             acs_objects.object_id%TYPE;
begin

  select
    live_revision into v_revision_id
  from
    cr_items
  where
    item_id = get_live_revision__item_id;

  return v_revision_id;
 
end;$$ language plpgsql;