Re: Trouble matching a nested value in JSONB entries

Oleg,

1 | {"group_id": 1}
2 | {“group_id": 1}
3 | {“group_id": 2}
4 | {“group_id": 3}

PS: Please note that I am currently at postgres 9.5. An update, if
necessary, would be possible though.

Upgrade, please !

I have only master 11beta2 right now:

select * from qq where js @> '{"group_id":1}';
id | js
----+-----------------
1 | {"group_id": 1}
2 | {"group_id": 1}
(2 rows)

thanks for your answer. Your code does work fine on 9.5 already; what I would like to achieve is to get records where the group_id entry is 1 or 2, and a fear that

select * from mytable where (metadata @> '{"group_id":1}') OR (metadata @> '{"group_id”:2}’)

• while doable - would not make the best use of existing indices.

Any more ideas?
Best,
/eno