--
-- file_storage__get_root_folder/1
--
create or replace function file_storage__get_root_folder(
  integer
) returns int4 as $$
  -- fs_root_folders.folder_id%TYPE 
declare
        get_root_folder__package_id  alias for $1;
        v_folder_id                  fs_root_folders.folder_id%TYPE;
begin
        select folder_id into v_folder_id 
        from fs_root_folders
        where package_id = get_root_folder__package_id;

        return v_folder_id;

end;$$ language plpgsql;