word search

Поиск
Список
Период
Сортировка
Искать

word search

От:
Bruce Young <hbrucey@yahoo.com>
Дата:
Hi list..
how do you guys search for a given word using postgresql.
Not matching characters like ... select word from text where word ~ 'myword';

i am trying to return values that only have that particular word string in a
text field.  
any help appreciated. thanks

  - bruce

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

Re: word search

От:
Rajesh Kumar Mallah <mallah@trade-india.com>
Дата:


you can use contrib/tsearch . which is very fast (becoz it
uses gist indexes) and supports stemming.


regds
mallah.

On Monday 10 Mar 2003 8:45 am, Bruce Young wrote:
> Hi list..
> how do you guys search for a given word using postgresql.
> Not matching characters like ... select word from text where word ~ 'myword';
> 
> i am trying to return values that only have that particular word string in a
> text field.  
> any help appreciated. thanks
> 
>   - bruce
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 
> 

-- 

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
FAQ