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
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 |