postgresql7.1 select survsimp_response__new ( :response_id, :survey_id, null, 'f', :user_id, :creation_ip, :survey_id ) insert into survsimp_question_responses (response_id, question_id, clob_answer) values (:response_id, :question_id, :clob_answer) select content_item__new ( varchar :name, null, null, null, now(), :user_id, null, :creation_ip, 'content_item', 'content_revision', null, null, 'text/plain', null, null, 'file' ) select acs_rel__new ( null, 'user_blob_response_rel', :user_id, :item_id, null, null, null ) declare v_revision_id integer; begin v_revision_id := content_revision__new ( 'A Blob Response', null, now(), :guessed_file_type, null, 'not_important', :item_id, null, now(), :user_id, :creation_ip ); update cr_items set live_revision = v_revision_id where item_id = :item_id; return v_revision_id; end; update cr_revisions set content = '[cr_create_content_file $item_id $revision_id $tmp_filename]' where revision_id = :revision_id