Postgresql operator does not exist: numeric = character varying

时间:2019-12-20 20:44:58   收藏:0   阅读:829
select  cast(series_id as varchar(64)),series_name  from svcm_t_series_res;

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

原文:https://www.cnblogs.com/penghq/p/12074832.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!