Text Search

Greg Elisara <elisara@world-net.co.nz>

From: Greg Elisara <elisara@world-net.co.nz>
To: pgsql-novice@postgresql.org
Date: 2001-08-11T04:47:58Z
Lists: pgsql-novice
Hi folks. I have a product table (music cds) that stores a review in one 
of the columns (datatype - text). The copy for the review can hold 
anywhere between 100-1500 words. The table holds a little over 200, 000 
rows.

I want to set up a way to search through the table using keyword 
searches on the reviews. What is the best way to approach this? Any help 
would be welcome.

Regards. Greg.