postgresql7.1 select 1 where exists (select name from cr_items where parent_id = :parent_folder_id and name = :encoded_filename) select file_storage__new_file ( :encoded_filename, :parent_folder_id, :user_id, :creation_ip, :indb_p, :file_id, :package_id ); select file_storage__new_version ( :title, :description, :mime_type, :file_id, :user_id, :creation_ip ); update cr_revisions set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]] where revision_id = :revision_id update cr_revisions set content_length = lob_length(lob) where revision_id = :revision_id select content_item__relate( :homework_file_id, :correction_file_id, 'homework_correction', null, 'cr_item_rel' );