Re: BETWEEN operator not indexed

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: j(at)wezel(dot)name, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: BETWEEN operator not indexed
Date: 2022-05-03 11:43:26
Message-ID: B2F0325A-0771-4CBF-9719-788CDE990726@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

> On 3 May 2022, at 07:23, PG Doc comments form <noreply(at)postgresql(dot)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/

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2022-05-03 12:02:13 Re: BETWEEN operator not indexed
Previous Message PG Doc comments form 2022-05-03 05:23:53 BETWEEN operator not indexed