Changes in /contrib/fulltextindex
От | Florian Helmberger |
---|---|
Тема | Changes in /contrib/fulltextindex |
Дата | |
Msg-id | OPEOLKEAAIMGBAMJNACKAENAEJAA.f.helmberger@uptime.at обсуждение исходный текст |
Список | pgsql-patches |
Hi. I have done some changes and improvements to the fulltextindex trigger (contrib/fulltextindex). As these changes affects among other things the parameter list I would like to ask the maintainer about his thoughts before I submit a patch. And there comes the problem - there is no explizit maintainer listed in the accompanying docs. The last changes according to the cvs log has been done by Bruce Momjian. Maybe the original author is subscribed to this list and can get in touch with me because I'm kind of new to incorporation patches to a open source project. The changes made include: + Changed the split up behaviour from checking via isalpha to using a list of delimiters as isalpha is a pain used with data containing german umlauts, etc. ATM this list contains: " ,;.:-_#/*+~^°!?\"\\§$%&()[]{}=<>|0123456789\n\r\t@µ" + If the do be indexed field has'nt changed, the indexing will not be done. This way unnecessary redindexing of fields not affected by an update can by omited. + There is a new field 'word' of type BOOL in the index table. Using this field, it is possible to do 'full word' and 'substring' searches. + The text gets no longer lowercased before it is written into the index table. This way it is possible to to casesensitive and incasesenstive (via a functional index using lower) searches. + Added functionality to prevent indexing of duplicate words (this is one item of the todo list in fti.c) using a hash table. As this is chained to a significant loos of performance and depends on the indexed data, this can be turned on or off via a newly introduced parameter. -Florian -- "Computers are useless. They can only give you answers." -- Pablo Picasso.
В списке pgsql-patches по дате отправления: