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

declare
  get_label__folder_id              alias for $1;  
  v_label                           cr_folders.label%TYPE;
begin

  select 
    label into v_label 
  from 
    cr_folders       
  where 
    folder_id = get_label__folder_id;

  return v_label;
 
end;$$ language plpgsql;