Re: [GENERAL] Combine multiple text search configuration

2017-11-12 Thread Johannes Graën
Hi, On 2017-11-06 09:17, hmidi slim wrote: > Hi, > I want to know if I can combine multiple text search configurations when > I tried to use FTS. > Is there any options like this: > *to_tsvector(['english', 'french'], document)* > * > * > Trying to create a new text configuration: > *Create text

Re: [GENERAL] Combine multiple text search configuration

2017-11-12 Thread Johannes Graën
On 2017-11-07 08:27, hmidi slim wrote: > Hi,  > Thank for your proposition but when to use this query :  > (to_tsvector('english', document) || to_tsvector('french', document)) @@ > (to_tsquery('english', query) || to_tsquery('french', query)) > I think that the performance decrease and not a good

Re: [GENERAL] Combine multiple text search configuration

2017-11-09 Thread Aleksandr Parfenov
On Thu, 9 Nov 2017 09:11:07 +0100 Johannes Graën wrote: > On 2017-11-07 08:27, hmidi slim wrote: > > Hi,  > > Thank for your proposition but when to use this query :  > > (to_tsvector('english', document) || to_tsvector('french', > > document)) @@ (to_tsquery('english', query) || to_tsquery('fren

Fwd: Re: [GENERAL] Combine multiple text search configuration

2017-11-09 Thread Johannes Graën
On 2017-11-07 08:27, hmidi slim wrote: > Hi,  > Thank for your proposition but when to use this query :  > (to_tsvector('english', document) || to_tsvector('french', document)) @@ > (to_tsquery('english', query) || to_tsquery('french', query)) > I think that the performance decrease and not a good

Re: [GENERAL] Combine multiple text search configuration

2017-11-06 Thread hmidi slim
Hi, Thank for your proposition but when to use this query : (to_tsvector('english', document) || to_tsvector('french', document)) @@ (to_tsquery('english', query) || to_tsquery('french', query)) I think that the performance decrease and not a good solution for big amount of data. Is it? 2017-11-0

Re: [GENERAL] Combine multiple text search configuration

2017-11-06 Thread Johannes Graën
Hi, On 2017-11-06 09:17, hmidi slim wrote: > Hi, > I want to know if I can combine multiple text search configurations when > I tried to use FTS. > Is there any options like this: > *to_tsvector(['english', 'french'], document)* > * > * > Trying to create a new text configuration: > *Create text

[GENERAL] Combine multiple text search configuration

2017-11-06 Thread hmidi slim
Hi, I want to know if I can combine multiple text search configurations when I tried to use FTS. Is there any options like this: *to_tsvector(['english', 'french'], document)* Trying to create a new text configuration: *Create text search configuration test (copy=simple)* *Alter text search config