PostgreSQL之分割字符串

最新推荐文章于 2025-06-20 11:21:19 发布

原创最新推荐文章于 2025-06-20 11:21:19 发布 · 1w 阅读

CC 4.0 BY-SA版权

select s.resourceid, (cast (s.confvalue_array[1] as INTEGER)*60*60*60 + cast (s.confvalue_array[2] as INTEGER)*60*60 + cast (s.confvalue_array[3] as INTEGER)*60 + cast (s.confvalue_array[3] as INTEGER)) from (select resourceid,string_to_array(confvalue, ':') as confvalue_array from am_host_config_info where attributeid=10008 and latest=1 and resourceid in (%s)) s

https://www.jianshu.com/p/8daa3cf55c37
强转时null的处理：
https://stackoverflow.com/questions/9218351/postgres-check-if-null-then-cast-to-numeric