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