On Mar 1, 2006, at 6:54 , flood wrote:
> Unfortunately I can not seem to get my query to use PG's full text
> indexing, it keeps doing a seq scan:
>
> EXPLAIN
> SELECT t1.id, t2.id
> FROM test1 t1, test2 t2
> WHERE lower( t1.keyword ) ~ ( lower ( '^' || t2.article ));
It doesn't appear that you're using tsearch2. PostgreSQL does not
include full text search in the basic installation. Have you
installed tsearch2?
Michael Glaesemann
grzm myrealbox com