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

declare
  get_revision_count__item_id   alias for $1;  
  v_count                       integer;       
begin

  select
    count(*) into v_count
  from 
    cr_revisions
  where
    item_id = get_revision_count__item_id;

  return v_count;
 
end;$$ language plpgsql;