Full text search in PostgreSQL 8.4

From: Konstantin Pavlov <varicond(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Full text search in PostgreSQL 8.4
Date: 2009-07-19 21:17:57
Message-ID: 902187.75174.qm@web112520.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I recently upgraded to version 8.4 and now full text search with russian configuration is not working:

template1=# create database test encoding='win1251';
test=# create table test ("test" varchar(255));
test=# insert into test values ('тест');
test=# select * from test where to_tsvector('russian', test) @@ to_tsquery('russian', 'тест');

In 8.3 version I have result:
test
------
тест
(1 запись)


In 8.4 I have this notice and 0 rows with any table values:
NOTICE: text-search query contains only stop words or doesn't contain lexemes, ignored
test
------
(0 rows)

Why it may not working in 8.4 version?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2009-07-19 22:58:19 Understanding sequential versus index scans.
Previous Message Sam Mason 2009-07-19 21:00:23 Re: timestamp with time zone tutorial