FTS wildcard and custom ispell dictionary problem - Mailing list pgsql-hackers

From darklow
Subject FTS wildcard and custom ispell dictionary problem
Date
Msg-id AANLkTimTjYvuu3r7ANAeNjY-J=2G4bVFpwg_dvy7GM1c@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hello,

 I am using PostgreSQL 8.4 full text search in following way:
 Custom FTS configuration called "dc2" with these dictionaries in
following order for asciihword token: latvian_ispell, english_stem,
russian_stem

 Latvian ispell dictionary contains words with different endings but
same meaning (latvian langiage specifics, plural words, etc)

 The problem starts when using wildcard :* to_tsquery syntax.

 For example. If i look for the word "kriev" i am automatically adding
wildcard using syntax:  to_tsquery('dc2', 'kriev:*');By searching kriev:* FTS founds word "krievs" in latvian_ispell
dictionary which is totally okei.
SELECT * from ts_debug('dc2', 'kriev:*');  alias   |   description   | token |
dictionaries                       |   dictionary   | lexemes

-----------+-----------------+-------+----------------------------------------------------------+----------------+----------asciiword
|Word, all ASCII | kriev | 
{latvian_ispell,english_stem,russian_stem} | latvian_ispell | {krievs}blank     | Space symbols   | :*    | {}


If understand correctly now database uses not kriev:* but krievs:* for
following queries.
And here is the problem, data contains also word: Krievija, and in
this case search doesn't find it, because it looks for Krievs:* and
not Kriev:* anymore.

Is there any solution anone could suggest to get results by both
criterias - kriev:* (starting query) and krievs:* (founded in ispell
dict).
Only idea i had is to somehow combine two tsqueries one -
to_tsquery('dc2', 'kriev:*') and to_tsquery('english', 'kriev:*'); so
the search looks for both - kriev:* and krievs:* but anyway didnt
figured out any syntax i could use :(

Thanks


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PL/pgsSQL EXECUTE USING INTO
Next
From: Tom Lane
Date:
Subject: Re: wip: functions median and percentile