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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster