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
