postgresql jsonb 数控类型处理

参看来源：

https://www.cnblogs.com/liuxiaoji/p/16997773.html 

https://www.cnblogs.com/mysummary/p/12310256.html

https://blog.csdn.net/m0_37996629/article/details/127565085

(48条消息) Postgresql杂谈 05—Postgresql中的JSON和JSONB类型_jsonb格式_HymanLiuTS的博客-CSDN博客

 

下面一个最简单的sql: 模糊查询  返回json中的值， 排序 分页  

jsonbstr =  {"age",7911.2344}

SELECT
    jsonbstr -> 'age' as age
FROM
    user_json 
WHERE
    jsonbstr ->> 'age' like '7911.23%' 
ORDER BY
    jsonbstr -> 'age' 
    LIMIT 2

 

 

SELECT
       sum(    
             
              (jsonbstr  ->> 'age' )::int
             
             )  as age
FROM
    user_json