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?
Which is included in the Postgr
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 usin
