我正在寻找一种方法来查找Postgres类型为“jsonb”的列中是否存在字符串,该列具有以下值:
id | numbers(jsonb)
1 | ["54954565","16516516","565196212"]
2 | ["195195159","252432","275782872"]
3 | ["54954565","61595161","728278"]
4 | ["245735435","75454","2782"]
例如:
如果“16516516”存在于与任何数字条目对应的数组中,我想要获取整个行。
所以,如果我查询“16516516”。
我应该获得的行是:
id | numbers
1 | ["54954565","16516516","565196212"]```