| From: | PostgreSQL Admin <postgres(at)productivitymedia(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Tsearch |
| Date: | 2008-06-12 12:47:44 |
| Message-ID: | 48511AF0.30306@productivitymedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
this is a small sample of the data:
short_desc
| long_desc
----------------------------------------------------------+------------------------------------------------------------------------
CHICKEN,BROILERS OR FRYERS,LEG,MEAT&SKN,CKD,FRIED,BATTER | Chicken,
broilers or fryers, leg, meat and skin, cooked, fried, batter
Is the best method of search through this data full text search via
tsearch or some other method. I'm running version 8.3
say I want to search for chicken skin?
Thanks for the advice,
J
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harold A. Giménez Ch. | 2008-06-12 13:31:45 | COPY command and required file permissions |
| Previous Message | Steve Crawford | 2008-06-11 19:01:29 | Re: Different type of query |