On Sun, Oct 09, 2005 at 10:23:13PM -0500, Announce wrote:
> A. Any suggestions for doing full-text searches in Postgres?
See the contrib/tsearch2 and contrib/pg_trgm modules.
> B. How should the fields be defined? Should they be VARCHAR with a character
> limit or just TEXT,etc?
The underlying implementation is the same so ultimately it probably
doesn't matter. Some people like to use TEXT with a CHECK constraint
on the length because it's easier to change, especially in versions
of PostgreSQL prior to 8.0.
In response to
pgsql-novice by date
|Next:||From: Prasad dev||Date: 2005-10-10 12:10:27|
|Subject: Stored Procedures Basics|
|Previous:||From: Announce||Date: 2005-10-10 03:23:13|
|Subject: Text Searching?|