| 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: | Whole Thread | Raw Message | 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 |