Re: How to use Logical Operators in Fulltext Search?

Gaini Rajeshwar <raja.rajeshwar2006@gmail.com> writes:
> I am doing a fulltext search something like this:

> SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR
> tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)

Since you haven't told us what those functions do, we're just guessing.
But I would suggest that if you can use | within a single tsquery,
it'll probably run faster.

            regards, tom lane