我刚刚完成将84个存储过程从MySQL转换为PostgreSQL函数。唯一没有弄清楚的是如何处理replace()调用。这个函数在PostgreSQL中不存在。我相信以前有人必须这样做。有什么建议么?将MySQL存储过程转换为PostgreSQL函数。我如何处理这些replace()调用?
set @sql="CREATE TABLE `tbodefcall...(An UnGodly Amount of code that creates tables ...honeid_cd_idx (PhoneID,CallDate);";
set @sql = Replace(@sql, 'tbodefcallback', concat('tbo_callback',_ProjectID));
set @sql = Replace(@sql, 'tbodefcontact', concat('tbo_contact',_ProjectID));
set @sql = Replace(@sql, 'tbodefscriptkvota', concat('tbo_scriptkvota',_ProjectID));
set @sql = Replace(@sql, 'tbodefscript', concat('tbo_script',_ProjectID));
set @sql = Replace(@sql, 'tbodeftermcode', concat('tbo_termcode',_ProjectID));
set @sql = Replace(@sql, 'tbodefprojectlogon', concat('tbo_projectlogon',_ProjectID));
set @sql = Replace(@sql, 'tbodefcomment', concat('tbo_comment',_ProjectID));
set @sql = Replace(@sql, 'tbodefvoicerecorder', concat('tbo_voicerecorder',_ProjectID));
set @sql = Replace(@sql, 'tbodefquestiongroup', concat('tbo_questiongroup',_ProjectID));
set @sql = Replace(@sql, 'tbodefquestion', concat('tbo_question',_ProjectID));
感谢您的任何帮助或建议。你们在帮助我完成这个项目中摇摆不定!