Is it possible to combine multiple text search configuration in FTS on postgresql?

user_6548980 0
Viewed 311

I tried to combine multiple text search to use it into text search on postgresql. I tried :

Create text search configuration test (
copy = english, french
)

But this didn't work:

text search configuration parameter "french" not recognized

I have a column which mixed of english french words and I want to get multiple configuration texts to search the queries items. Example:

to_tsvector('test', words) @@ to_tsquery('test','activité')
to_tsvector('test', words) @@ to_tsquery('test', 'mystery')

How can I mix different text configurations to get result when I look for a french or english word?

full-text-search postgresql
1 Answers

The French text search configuration uses French stemming (the french_stem dictionary), while for English english_stem is used.

How do you want to stem for both? You could create a text search configuration that applies both stemmers, but I guess that the result would not be convincing. Similar for stop words.

You can explicitly specify the text search configuration in the query if you know what language you want to search for.

user_64643080
Related