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