small but useful patches for text search

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: small but useful patches for text search
Date: 2009-03-16 16:07:51
Message-ID: Pine.LNX.4.64.0903161857200.31919@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi there,

I and Teodor have several small, but useful patches for text search:

1. Support of filtering dictionaries and unaccent dictionary/function.
This is often requested feature, which solves, for example,
problem with correct headlines for text with accents.
See example and docs http://www.sai.msu.su/~megera/wiki/unaccent

2. Add prefix search support to the synonym dictionary.
Star sign '*' at the end of definition word indicates,
that definition word is a prefix and to_tsquery() function will transform
that definition to the prefix search format.
Notice, it is ignored in to_tsvector().
Some examples http://www.sai.msu.su/~megera/wiki/2009-03-13

There are limitations - no support for thesaurus dictionary,
ts_debug doesn't support all these features (it needs to be rewritten
to C).

There is no problem with back compatibility.

We would like to have your opinion what to do with these patches - leave them
for 8.5 or provide them to hackers to review for 8.4.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2009-03-16 16:26:43 Re: Problem with accesing Oracle from plperlu functionwhen using remote pg client.
Previous Message Tomasz Olszak 2009-03-16 15:09:58 Re: Problem with accesing Oracle from plperlu functionwhen using remote pg client.