Re: How to use Logical Operators in Fulltext Search? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to use Logical Operators in Fulltext Search?
Date
Msg-id 27025.1256132543@sss.pgh.pa.us
Whole thread Raw
In response to How to use Logical Operators in Fulltext Search?  (Gaini Rajeshwar <raja.rajeshwar2006@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index Scan/Bitmap Index Scan for queries with FTS and ORDER+LIMIT
Next
From: Tom Lane
Date:
Subject: Re: How to send multiple parameters to a pl/pgsql function