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