From: Tom Lane <tgl@sss.pgh.pa.us>
To: postgresql@wchargin.com
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: No search results for "BETWEEN"
Date: Fri, 24 Jun 2022 10:40:17 -0400
Message-ID: <355733.1656081617@sss.pgh.pa.us> (raw)
In-Reply-To: <165600177616.879893.13980346362169630574@wrigleys.postgresql.org>
References: <165600177616.879893.13980346362169630574@wrigleys.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, postgresql@wchargin.com, pgsql-docs@lists.postgresql.org
Subject: Re: No search results for "BETWEEN"
In-Reply-To: <355733.1656081617@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox