How to Get only those rows whose jsonb[] column contains an object with specific key-value
i have a table and it has a column of "members" , it is of type jsonb defined as array , for example
[{id: 2, role: "member"}, {id: 4, role: "admin"}]
how can i get only those rows whose "members" column contains an object with "id": 3 etc
[{id: 2, role: "member"}, {id: 4, role: "admin"}]
how can i get only those rows whose "members" column contains an object with "id": 3 etc
