db-search postgres

[Anon]

Hi -
I want to search a datebase with texts for some searchwords inputted by the user. I have the search words seperated and i was wondering how to go about searching easiest/smartest??
Is there any search functions in the db (postgresql).

cheers
Kim

[Anon]

There's several ways of doing it. I suggest reading the contrib/fulltextindex or contrib/tsearch in the postgres distribution.

Alternatively a trivial way of searching is like this:

select * from articles where title ilike '%keyword1%' and title ilike '%keyword2%';

However this will run relatively slowly - I'd suggest avoiding doing this for large amounts of data.

Chris

[Anon]

Hi again -

what is the contrib/fulltextindex and contrib/tsearch. Is it the manuel which can be dl at postgresql.org ?

cheers kim

[Anon]

They are part of the postgres source distibution. Note that tsearch is only in postgres 7.2.

To install contrib/fulltextindex, you'd do something like this:

• Download the source
• run configure
• cd contrib/fulltextindex
• gmake all
• gmake install

Then you read the docs to see how to use the contrib.

Same for tsearch. There's a gmake installcheck option though as well.

Chris