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.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
