Postgresql operator does not exist: numeric = character varying

select  cast(series_id as varchar(64)),series_name  from svcm_t_series_res;

原来series_id是numeric型,现在转换为varchar(64);

posted @ 2019-12-20 19:59  小泉哥  阅读(5878)  评论(0编辑  收藏  举报