XanderCheung
热度 6488 评论 0 赞 0
User(id: integer, setting: jsonb)
User.where("setting ->> 'sequence' = ?", '1')
查询User setting字段,key为sequence 值为'1'的记录
SELECT "users".* FROM "users" WHERE (setting ->> 'sequence' = '1')