数据类型
array {18,19,20}
// 查询年龄等于18的
SELECT * FROM A表 WHERE id=1 AND 18=ANY(age)
// 查询年龄大于18的
SELECT * FROM A表 WHERE id=1 AND 18<ANY(age)
jsonb
例子:content ={"name": 张三, "age": 57, "sex": "男"}
SELECT * FROM A表 WHERE (content::json#>>'{name}'):: VARCHAR ='张三' AND (content::json#>>'{age}'):: INTEGER =57 AND deleted_at is NULL ORDER BY created_at DESC