postgresql7.1
select 1
where exists (select name
from cr_items
where parent_id = :parent_folder_id
and name = :title)
select file_storage__new_file (
:title,
:parent_folder_id,
:user_id,
:creation_ip,
:indb_p,
:file_id
);
select file_storage__new_version (
:filename,
:description,
:mime_type,
:file_id,
:user_id,
:creation_ip
);
update cr_revisions
set content = empty_blob()
where revision_id = :revision_id
returning content into :1
update cr_revisions
set content_length = dbms_lob__getlength(content)
where revision_id = :revision_id
select content_item__relate(
:homework_file_id,
:correction_file_id,
'homework_correction'
);