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

Re: Text Searching?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Announce <truthhurts(at)insightbb(dot)com>
Cc: Postgres Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Text Searching?
Date: 2005-10-10 03:55:18
Message-ID: 20051010035518.GA87538@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Prasad devDate: 2005-10-10 12:10:27
Subject: Stored Procedures Basics
Previous:From: AnnounceDate: 2005-10-10 03:23:13
Subject: Text Searching?

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