postgresql 用sum某个字段求和，转换int 类型

最新推荐文章于 2024-05-06 21:44:16 发布

经典的错误&标准的零分

最新推荐文章于 2024-05-06 21:44:16 发布

阅读量1.9k

点赞数 2

文章标签： postgresql 数据库

本文链接：https://blog.csdn.net/weixin_45948414/article/details/126249710

版权

gp_sydb=# select sum(qyt) from dwd_awws_i;
ERROR:  function sum(character varying) does not exist
LINE 1: select sum(qyt) from dwd_awws_i;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
gp_sydb=# select sum(qyt) from dwd_awws_i;
ERROR:  function sum(character varying) does not exist
LINE 1: select sum(qty) from dwd_awws_i;
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
gp_sydb=# select sum(qyt::int) from dwd_awws_i;
 sum  
------
 2455
(1 row)