pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedNo search results for "BETWEEN"
3+ messages / 3 participants
[nested] [flat]
* No search results for "BETWEEN"
@ 2022-06-23 16:29 PG Doc comments form <noreply@postgresql.org>
2022-06-24 14:40 ` Re: No search results for "BETWEEN" Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2022-06-23 16:29 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: postgresql@wchargin.com
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).
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: No search results for "BETWEEN"
2022-06-23 16:29 No search results for "BETWEEN" PG Doc comments form <noreply@postgresql.org>
@ 2022-06-24 14:40 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-06-24 14:49 ` Re: No search results for "BETWEEN" Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2022-06-24 14:40 UTC (permalink / raw)
To: postgresql@wchargin.com; +Cc: pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: No search results for "BETWEEN"
2022-06-23 16:29 No search results for "BETWEEN" PG Doc comments form <noreply@postgresql.org>
2022-06-24 14:40 ` Re: No search results for "BETWEEN" Tom Lane <tgl@sss.pgh.pa.us>
@ 2022-06-24 14:49 ` Magnus Hagander <magnus@hagander.net>
0 siblings, 0 replies; 3+ messages in thread
From: Magnus Hagander @ 2022-06-24 14:49 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: postgresql@wchargin.com; pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-06-24 14:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-06-23 16:29 No search results for "BETWEEN" PG Doc comments form <noreply@postgresql.org>
2022-06-24 14:40 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-06-24 14:49 ` Magnus Hagander <magnus@hagander.net>
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