PG Doc comments form <noreply@postgresql.org> writes:
> Searching for "the between predicate simplifies range tests" does turn
> up a hit for that page, so it's indexed, but the words "The BETWEEN" are
> not set in bold in the search result. Perhaps "BETWEEN" is being treated
> as a stop word, even though it's capitalized and an SQL keyword?
A quick grep shows that if "between" weren't a stopword, it would
produce almost 600 hits in our core docs, most of which are not what
you're looking for. So I concur with somebody's apparent decision
to make it a stopword.
Use the index.
regards, tom lane