这sql代码执行出现以下问题是什么原因?
邢柏 2018-06-22 02:53:22 [SQL]with abx as
(
select icustay_id
, suspected_infection_time
, specimen, positiveculture
, antibiotic_name
, antibiotic_time
, ROW_NUMBER() OVER
(
PARTITION BY icustay_id
ORDER BY suspected_infection_time
) as rn
from abx_micro_poe
)
select
ie.icustay_id
, antibiotic_name
, antibiotic_time
, suspected_infection_time
, specimen, positiveculture
from icustays ie
left join abx
on ie.icustay_id = abx.icustay_id
and abx.rn = 1
order by ie.icustay_id;
[Err] 错误: 操作符不存在: integer = character varying
LINE 23: on ie.icustay_id = abx.icustay_id
^
HINT: 没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换.