1CREATE TABLE fruits (
2  id int,
3  items jsonb
4);
5INSERT INTO fruits VALUES (1, '{"apple":  true}');
6INSERT INTO fruits VALUES (2, '{"banana": false}');
7INSERT INTO fruits VALUES (3, '{"peach":  true}');
8SET enable_seqscan = on;
9SET enable_indexscan = off;
10SET enable_bitmapscan = off;
11SELECT id, items
12  FROM fruits
13 WHERE items &` 'boolean == true'
14 ORDER BY id;
15 id |      items
16----+-----------------
17  1 | {"apple": true}
18  3 | {"peach": true}
19(2 rows)
20
21DROP TABLE fruits;
22