Skip site navigation (1) Skip section navigation (2)

Tsearch

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 (view raw or flat)
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

In response to

pgsql-sql by date

Next:From: Harold A. Giménez Ch.Date: 2008-06-12 13:31:45
Subject: COPY command and required file permissions
Previous:From: Steve CrawfordDate: 2008-06-11 19:01:29
Subject: Re: Different type of query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group