BETWEEN operator not indexed
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/functions-comparison.html
Description:
The BETWEEN operator can't be found by searching.
On 3 May 2022, at 07:23, PG Doc comments form <noreply@postgresql.org> wrote:
The BETWEEN operator can't be found by searching.
It is actually indexed, but it can indeed not be searched on its own.
<indexterm>
<primary>BETWEEN</primary>
</indexterm>
<indexterm>
<primary>BETWEEN SYMMETRIC</primary>
</indexterm>
A wild guess; perhaps between is defined in a stopwords list for searching
somewhere?
--
Daniel Gustafsson https://vmware.com/
On 2022-May-03, Daniel Gustafsson wrote:
A wild guess; perhaps between is defined in a stopwords list for searching
somewhere?
Our very own src/backend/snowball/stopwords/english.stop contains it.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/