Postgres Pro
Downloads
Home   >   mailing lists

Tsearch - Mailing list pgsql-sql

From PostgreSQL Admin
Subject Tsearch
Date
Msg-id 48511AF0.30306@productivitymedia.com
Whole thread Raw
In response to Re: Different type of query  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-sql
Tree view 
this is a small sample of the data:
                       short_desc                        
|                               long_desc                               

----------------------------------------------------------+------------------------------------------------------------------------CHICKEN,BROILERS
ORFRYERS,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

pgsql-sql by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Different type of query
Next
From: "Harold A. Giménez Ch."
Date:
Subject: COPY command and required file permissions