Little problem with tsearch
От | Christopher Kings-Lynne |
---|---|
Тема | Little problem with tsearch |
Дата | |
Msg-id | 08d601c2ed00$97cf3fc0$6500a8c0@fhp.internal обсуждение исходный текст |
Список | pgsql-hackers |
Having a little problem with 7.3's tsearch: usa=# select brand,description, ftiidx from food_foods where description ilike '%frapp%'; brand | description | ftiidx -----------+---------------------------------------------------------------- -------+-------------------------------------------------------------------- -----------------Starbucks | Ice Blended Drinks: Creme Frappuccino® Coconut | 'ice' 'blend' 'creme' 'drink' 'coconut' 'starbuck' 'frappuccino®'Starbucks | Ice Blended Beverages: Frappuccino® Choc.Brownie | 'ice' 'choc' 'blend' 'browni' 'beverag' 'starbuck' 'frappuccino®'Starbucks | Ice Blended Beverages: Frappuccino® Coffee | 'ice' 'blend' 'coffe' 'beverag' 'starbuck' 'frappuccino®'Starbucks | Ice Blended Beverages: Frappuccino® Espresso | 'ice' 'blend' 'beverag' 'espresso' 'starbuck' 'frappuccino®' See how the (r) symbol is not being stemmed? That means that it's not possible for anyone to search for the word 'frappacino'. Is there any fix for this? A similar thing happens with the tradmark symbol. Chris
В списке pgsql-hackers по дате отправления: