Re: No search results for "BETWEEN" - Mailing list pgsql-docs

From Tom Lane
Subject Re: No search results for "BETWEEN"
Date
Msg-id 355733.1656081617@sss.pgh.pa.us
Whole thread Raw
In response to No search results for "BETWEEN"  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: No search results for "BETWEEN"  (Magnus Hagander <magnus@hagander.net>)
List pgsql-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



pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: No search results for "BETWEEN"
Next
From: Magnus Hagander
Date:
Subject: Re: No search results for "BETWEEN"