usa=# select food_id, brand,description,ftiidx from food_foods where description ilike '%herring%';
 food_id |         brand          |                 description                  |                         ftiidx
---------+------------------------+----------------------------------------------+---------------------------------------------------------
   66245 | Kosher/Deli Foods      | Herring, Smoked                              | 'food' 'smoke' 'kosher/deli'
   66246 | Kosher/Deli Foods      | Herring, in Sour Cream                       | 'food' 'sour' 'cream' 'kosher/deli'
    4590 | - Generic -            | Fish oil, herring                            | 'oil' 'fish' 'gener'
   70737 | - Average All Brands - | Finfish, herring, Pacific, raw               | 'raw' 'brand' 'pacif' 'averag' 'finfish'
   70738 | - Average All Brands - | Finfish, herring, Pacific, cooked, dry heat  | 'dri' 'cook' 'heat' 'brand' 'pacif' 'averag' 'finfish'
   70739 | - Average All Brands - | Finfish, herring, Atlantic, raw              | 'raw' 'brand' 'atlant' 'averag' 'finfish'
   70740 | - Average All Brands - | Finfish, herring, Atlantic, pickled          | 'brand' 'pickl' 'atlant' 'averag' 'finfish'
   70741 | - Average All Brands - | Finfish, herring, Atlantic, kippered         | 'brand' 'atlant' 'averag' 'kipper' 'finfish'
   70742 | - Average All Brands - | Finfish, herring, Atlantic, cooked, dry heat | 'dri' 'cook' 'heat' 'brand' 'atlant' 'averag' 'finfish'
   66026 | German                 | Herring, Pickled: Rollmops                   | 'pickl' 'german' 'rollmop'
   66027 | German                 | Herring, Pickled: w/Sour Cream               | 'cream' 'pickl' 'german' 'w/sour'
(11 rows)

usa=# select food_id, brand,description,ftiidx from food_foods where ftiidx ## 'herring';
NOTICE:  Query contains only stopword(s) or doesn't contain lexem(s), ignored
 food_id | brand | description | ftiidx
---------+-------+-------------+--------
(0 rows)