From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Bruce Young <hbrucey(at)yahoo(dot)com>, PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: word search |
Date: | 2003-03-10 09:46:28 |
Message-ID: | 200303101516.28849.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Abhishek Verma | 2003-03-10 10:06:24 | problem :unable to use arrow keys in psql |
Previous Message | Rajesh Kumar Mallah | 2003-03-10 09:45:18 | Re: Table Sizes |