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

From Magnus Hagander
Subject Re: No search results for "BETWEEN"
Date
Msg-id CABUevExsAZJnFav+=mW0BQFPkP70fbu1-+Cp99Onr_ED6T3+oA@mail.gmail.com
Whole thread Raw
In response to Re: No search results for "BETWEEN"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs
On Fri, Jun 24, 2022 at 4:40 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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.

It is a standard stopword in the snowball stemmers we ship, sadly. I don't think we have an easy way to say "use this dictionary and it's stopwords, except these couple of words that we want to not be stopwords"? Other than having to maintain a separate copy of the whole file and then forgetting to update it?

//Magnus

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: No search results for "BETWEEN"
Next
From: Noboru Saito
Date:
Subject: proposal: convert comments in documents to html comments