Little problem with tsearch

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Cc: <teodor(at)stack(dot)net>
Subject: Little problem with tsearch
Date: 2003-03-18 03:43:51
Message-ID: 08d601c2ed00$97cf3fc0$6500a8c0@fhp.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2003-03-18 03:52:16 Re: cursors outside transactions
Previous Message Neil Conway 2003-03-18 03:40:18 Re: [INTERFACES] Roadmap for FE/BE protocol redesign