Thread: 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/