您的当前位置:首页 > 最新IT资讯 > postgresql > pgsql转int类型
pgsql转int类型
所属分类: postgresql 2021-07-18 13:24:39 编辑:admin 浏览次数 523 次
如果超出上限::INT转换失败
用 cast(substring(b."adCode"::TEXT,1,4) as bigint)
select CASE WHEN b."adCode"::TEXT similar to '%00' THEN cast(substring(b."adCode"::TEXT,1,4) as bigint) ELSE cast(b."adCode" as bigint) END FROM
(select a."areaGmCode",a."objCode",a."objType",CASE WHEN a."adCode"::TEXT similar to '%000' THEN substring(a."adCode"::TEXT,1,6) ELSE a."adCode"::TEXT END FROM
(select "areaGmCode","objCode","objType",CASE WHEN "adCode"::TEXT similar to '%000' THEN substring("adCode"::TEXT,1,9) ELSE "adCode"::TEXT END FROM user_river_relationship) as a) as b
猜你喜欢
- 优化数据库的方法 2018-07-16
- pgsql常用命令 2018-07-23
- PostgreSQL字段自增 2018-08-09
- mysql常用操作 2018-08-13
- sql查询出来是语句进行自增排序 2018-08-29
- select查询算法优化 2018-09-27