1CREATE TABLE ids (
2  id integer
3);
4INSERT INTO ids VALUES (2);
5INSERT INTO ids VALUES (7);
6INSERT INTO ids VALUES (6);
7INSERT INTO ids VALUES (4);
8INSERT INTO ids VALUES (5);
9INSERT INTO ids VALUES (8);
10INSERT INTO ids VALUES (1);
11INSERT INTO ids VALUES (10);
12INSERT INTO ids VALUES (3);
13INSERT INTO ids VALUES (9);
14CREATE INDEX pgroonga_index ON ids
15  USING pgroonga (id pgroonga.int4_ops);
16SET enable_seqscan = off;
17SET enable_indexscan = off;
18SET enable_bitmapscan = on;
19SELECT id
20  FROM ids
21 WHERE id IN (6, 1, 7)
22 ORDER BY id ASC;
23 id
24----
25  1
26  6
27  7
28(3 rows)
29
30DROP TABLE ids;
31