Thread: No search results for "BETWEEN"

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/functions-comparison.html
Description:

For some reason, searching for "BETWEEN" (no quotes) on the docs site
returns no hits:

https://www.postgresql.org/search/?q=BETWEEN

This is surprising, because the comparison operator "BETWEEN" is in fact
well documented in section 9.2, "Comparison Functions and Operators":

https://www.postgresql.org/docs/14/functions-comparison.html

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?

It would be nice for this to appear in a Postgres search instead of
having to resort to a normal web search (whose results usually include
half a dozen blogspam entries before the actual desired docs).

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