FTS Configuration option - Mailing list pgsql-hackers

From Artur Zakirov
Subject FTS Configuration option
Date
Msg-id CAKNkYnxX=R3oSjtEOUoC2pJQJ6nNJkQKqz0SXqMViCmJ88HbnQ@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hello hackers,

Sometimes there is a need to collect lexems from various dictionaries.
For example, if we have a column with text in various languages.

Let's say there is a new option JOIN. This option will allow to parser
to append lexems from current dictionary and go to next dictionary to
get another lexems:

=> CREATE TEXT SEARCH CONFIGURATION multi_conf (COPY=simple);
=> ALTER TEXT SEARCH CONFIGURATION multi_conf   ALTER MAPPING FOR asciiword, asciihword, hword_asciipart,   word,
hword,hword_part   WITH german_ispell (JOIN), english_ispell, simple;
 

Here there are the following cases:
- found lexem in german_ispell, didn't found lexem in english_ispell.
Return lexem from german_ispell.
- didn't found lexem in german_ispell, found lexem in english_ispell.
Return lexem from english_ispell.
- didn't found lexems in dictionaries. Return lexem from simple.
- found lexems in both dictionaries. Return lexems from both.

Could be such option is useful to the community? Name of the option is
debatable.

Thank you!

-- 
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company



pgsql-hackers by date:

Previous
From: Michael Malis
Date:
Subject: Re: Merge Join with an Index Optimization
Next
From: Josh Berkus
Date:
Subject: Remove vacuum_defer_cleanup_age