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