--
-- content_item__get_content_type/1
--
create or replace function content_item__get_content_type(
  integer
) returns varchar as $$

declare
  get_content_type__item_id                alias for $1;  
  v_content_type                           cr_items.content_type%TYPE;
begin

  select
    content_type into v_content_type
  from 
    cr_items
  where 
    item_id = get_content_type__item_id;  

  return v_content_type;
 
end;$$ language plpgsql;