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,
>
--
Teodor Sigaev E-mail: teodor@sigaev.ru