Hi Oleg/Teodor,
I'm sorry to keep posting bugs without patches, but I'm just hoping you guys
know the answer faster than I...I know you're busy.
What does tsearch have against the word 'herring' (as in the fish). Why is
it considered a stopword?
Attached is example queries...
Chris
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)
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
