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

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

  select 
    content_item__get_content_type(target_id) into v_content_type
  from
    cr_symlinks
  where
    symlink_id = resolve_content_type__item_id;

  if NOT FOUND then 
     return null;
  end if;

  return v_content_type;
 
end;$$ language plpgsql;