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