CODEWITHSUNDEEP
postgresqlfull-text-search
Slim
Slim

Reputation: 6197

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

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?

Upvotes: 3

Views: 450

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247940

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.

Upvotes: 1

Related Questions