好好爱自己!

PostgreSQL sum typecasting as a bigint

https://stackoverflow.com/questions/20203081/postgresql-sum-typecasting-as-a-bigint

Question: 

  I am doing the sum() of an integer column and I want to typecast the result to be a bigint - to avoid an error. However when I try to use sum(myvalue)::bigint it still gives me an out of range error.

  Is there anything that I can do to the query to get this to work? Or do I have to change the column type to a bigint?

 

------------------

Answer:

  Try sum(myvalue::bigint)

 

 

The result is obviously bigger than what bigint could hold:

 

-9223372036854775808 to +9223372036854775807

 

Postgres returns numeric in such a case. You shouldn't have to do anything, it should just work without explicit cast.

 

If it doesn't, you can cast the base type to bigint, thereby forcing the result to be numeric in any case.

 

SELECT sum(myvalue::int8) ...

 

posted @   立志做一个好的程序员  阅读(501)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
阅读排行:
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· 25岁的心里话
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 按钮权限的设计及实现
历史上的今天:
2016-08-22 elasticSearch indices VS type
2016-08-22 一个不错的简历制作网站
2016-08-22 php active-record 设计模式

不断学习创作,与自己快乐相处

点击右上角即可分享
微信分享提示