Question regarding contrib/fulltextindexing

Hi Everybody,

I've been using Postgres for a few months now and have been very impressed with it so far. The user community is also very helpful!

I was wondering if the fulltextindex module would be useful in my situation.

On the document page,

http://techdocs.postgresql.org/techdocs/fulltextindexing.php

the explanation is that the module works well with like queries like this:

SELECT *
FROM table
WHERE
f1.string ~ '^perth
AND f2.string ~ '^stralia'

In my situation, I need to match exact words, so I've used regular expressions to search on a varchar(10000) field:

SELECT *
FROM table
WHERE description ~* ('[^a-zA-Z0-9]($keyword[$x])[^a-zA-Z0-9]');

Would this module still be useful in my situation?

Thanks,

Derek
--
_______________________________________________
Get your free email from http://www.graffiti.net

Powered by Outblaze