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


Tue, 18 Mar 2003 11:43:51 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Little problem with tsearch