postgresql - 错误：运算符不存在：数字 = 字符变化

Question

这是我遇到错误的地方。

SELECT incident_id, incident_name, incident_desc, incident_status,  
       root_cause_level_1, 
       root_cause_level_2, remediate_proj_name, remediate_proj_desc, remediate_proj_phase, start_date, end_date
FROM incident_details 
  INNER JOIN complain_details ON complain_details.complaint_id = incident_details.incident_id;

ERROR:  operator does not exist: numeric = character varying
LINE 3: ...complain_details ON complain_details.complaint_id = incident...
                                                            ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

我尝试输入 cast 不起作用。

标签： postgresql