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.