tsearch2: plainto_tsquery() with OR? - Mailing list pgsql-general

From cluster
Subject tsearch2: plainto_tsquery() with OR?
Date
Msg-id f99dfk$p6f$1@news.hub.org
Whole thread Raw
Responses Re: tsearch2: plainto_tsquery() with OR?
List pgsql-general
I have some questions related to tsearch2:

1) Is
    ...WHERE rank(myTsVector, myTsQuery) > 0 ...
just as fast as
    ...WHERE myTsVector @@ myTsQuery...
?


2)) I will use plainto_tsquery() to parse search keys entered by a
website user to a tsquery. However, if only some of the entered keywords
does not exist in the searched tsvectors (but others do), I would still
like the search result to be "true".
plainto_tsquery() glues each keyword together with "&". I search for a
plainto_tsquery() that glues the keywords with an "|" (the OR operator).
In that way, not ALL keywords are required to exist in the tsvector in
order for the row to be returned,

pgsql-general by date:

Previous
From: son@raider.co.nz
Date:
Subject: how to detect the backup database every day
Next
From: Nis Jørgensen
Date:
Subject: Re: finding reusable ids