Little problem with tsearch - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Little problem with tsearch
Date
Msg-id 08d601c2ed00$97cf3fc0$6500a8c0@fhp.internal
Whole thread Raw
List 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 by date:

Previous
From: Neil Conway
Date:
Subject: Re: [INTERFACES] Roadmap for FE/BE protocol redesign
Next
From: Hiroshi Inoue
Date:
Subject: Re: cursors outside transactions