# Postgresql Jsonb Functions and Operators

Source: https://blog.ferstar.org/posts/postgresql-jsonb-functions-operators-guide/





PG 对 json 的支持真是美如画

https://www.postgresql.org/docs/9.5/functions-json.html

比如 hello 表有个 result 字段长这样

```json
"result": {
        "items": [
            "warrants",
            "convertiables"
        ],
        "warrants": {
            "index": 10
        }
}
```

需要把`index`大于`0`的记录找出来

```sql
SELECT *
FROM hello
WHERE (result -> 'warrants' ->> 'index') :: INT > 0
```

爽的很啊