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