Skip to main content
The whitespace tokenizer splits only on whitespace. It also lowercases characters by default. 
CREATE INDEX search_idx ON mock_items
USING bm25 (id, (description::pdb.whitespace))
WITH (key_field='id');
To get a feel for this tokenizer, run the following command and replace the text with your own: 
SELECT 'Tokenize me!'::pdb.whitespace::text[];
Expected Response
      text
----------------
 {tokenize,me!}
(1 row)