参看来源:
https://www.cnblogs.com/liuxiaoji/p/16997773.html
https://www.cnblogs.com/mysummary/p/12310256.html
下面一个最简单的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