Re: Trouble matching a nested value in JSONB entries

[Enrico Thierbach]

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