select cast(series_id as varchar(64)),series_name from svcm_t_series_res；
原来series_id是numeric型，现在转换为varchar(64)；
Postgresql operator does not exist: numeric = character varying
原文：https://www.cnblogs.com/penghq/p/12074832.html
