Re: About TSearch2 Performance

Teodor Sigaev wrote:

> First one will be a bit faster
>
> Diogo Biazus wrote:
>
>> Hi,
>>
>> Is there any performance diference between the following SQL commands:
>>
>> SELECT * FROM documents WHERE content_ix @@
>> to_tsquery('word1&word2|word3');
>>
>> SELECT * FROM documents WHERE content_ix @@ to_tsquery('word1') AND
>> content_ix @@ to_tsquery('word2') OR content_ix @@ to_tsquery('word3');
>>
>> I'm having to do this on some complex querys to put LIKEs between
>> some ts_querys.
>> Does anyone has such experience?
>>
>> Thanks in advance,
>>
>
What do those @@ do for the statement?

--
"You are behaving like a man",
is an insult from some women,
a compliment from an good woman.