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,
--
Diogo Biazus
diogo(at)ikono(dot)com(dot)br
http://www.ikono.com.br