1CREATE TABLE memos (
2  id integer,
3  content text
4);
5INSERT INTO memos VALUES (1, 'It works.');
6INSERT INTO memos VALUES (2, 'I work.');
7INSERT INTO memos VALUES (3, 'I worked.');
8CREATE INDEX pgrn_index ON memos
9 USING pgroonga (content)
10  WITH (token_filters = 'none');
11SET enable_seqscan = off;
12SET enable_indexscan = on;
13SET enable_bitmapscan = off;
14SELECT id, content
15  FROM memos
16 WHERE content %% 'works';
17 id |  content
18----+-----------
19  1 | It works.
20(1 row)
21
22SELECT id, content
23  FROM memos
24 WHERE content %% 'work';
25 id | content
26----+---------
27  2 | I work.
28(1 row)
29
30SELECT id, content
31  FROM memos
32 WHERE content %% 'worked';
33 id |  content
34----+-----------
35  3 | I worked.
36(1 row)
37
38DROP TABLE memos;
39