FTS don't work - Mailing list pgsql-admin

From Martins Zarins
Subject FTS don't work
Date
Msg-id 3BBAE650.29990.A7CD914@localhost
Whole thread Raw
Responses Race condition in 7.1.2?
List pgsql-admin
Hi, all!

There is one full text search solution contributed with postgres
source (I use 7.1.3). And there is sed that

select id from fti where string ~ '^substring'

will use indexes.
But it don't.

As I find out index works only if I search like
SELECT id from fti where string = 'string';

How can I search for strings like 'strin%' and use index?


Mark

pgsql-admin by date:

Previous
From: "Michael B. Babakov"
Date:
Subject: How to make 'tail -f' in PostgreSQL?
Next
From: Steve Frampton
Date:
Subject: Race condition in 7.1.2?