FTS question

From: Damjan Rems <d_rems(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: FTS question
Date: 2008-07-01 06:05:06
Message-ID: 335679.14254.qm@web55204.mail.re4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I created a FTS index:
CREATE INDEX clients_fts ON clients USING gist( to_tsvector( 'english', name) )

I can do FTS queries like:
SELECT * FROM clients
WHERE to_tsvector('english',name) @@ to_tsquery( 'english','somestring');

But if I want to query just part of the string return set is empty:
SELECT * FROM clients
WHERE to_tsvector('english',name) @@ to_tsquery( 'english','somes');

returns no results.

Is it that postgresql doesn't support substring queries or have I missed something. I can not find anything on the net. Postgresql is v8.3.1.

by
TheR

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry - Zen Search SA 2008-07-01 07:37:23 Re: "out of balance" result on select from suspected index corruption [RESOLVED]
Previous Message EBIHARA, Yuichiro 2008-07-01 01:05:33 Re: server log files