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.
--
Michael Fuhr