Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nlqwI-0003En-KA
	for pgsql-docs@arkaria.postgresql.org; Tue, 03 May 2022 11:43:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nlqwG-0003HH-5T
	for pgsql-docs@arkaria.postgresql.org; Tue, 03 May 2022 11:43:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <daniel@yesql.se>)
	id 1nlqwF-0003H8-UC
	for pgsql-docs@lists.postgresql.org; Tue, 03 May 2022 11:43:31 +0000
Received: from smtp.outgoing.loopia.se ([93.188.3.37])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <daniel@yesql.se>)
	id 1nlqwD-0004VD-3r
	for pgsql-docs@lists.postgresql.org; Tue, 03 May 2022 11:43:31 +0000
Received: from s807.loopia.se (localhost [127.0.0.1])
	by s807.loopia.se (Postfix) with ESMTP id 2B87C2F1FCC4
	for <pgsql-docs@lists.postgresql.org>; Tue,  3 May 2022 13:43:27 +0200 (CEST)
Received: from s645.loopia.se (unknown [172.22.191.6])
	by s807.loopia.se (Postfix) with ESMTP id 1CA292E28AC8;
	Tue,  3 May 2022 13:43:27 +0200 (CEST)
Received: from s473.loopia.se (unknown [172.22.191.5])
	by s645.loopia.se (Postfix) with ESMTP id 036D6156E58F;
	Tue,  3 May 2022 13:43:27 +0200 (CEST)
X-Virus-Scanned: amavisd-new at amavis.loopia.se
X-Spam-Flag: NO
X-Spam-Score: -1
X-Spam-Level: 
X-Spam-Status: No, score=-1 tagged_above=-999 required=6.2
	tests=[ALL_TRUSTED=-1] autolearn=disabled
Received: from s899.loopia.se ([172.22.191.6])
	by s473.loopia.se (s473.loopia.se [172.22.190.13]) (amavisd-new, port 10024)
	with LMTP id 9-RqBE6VW3Ms; Tue,  3 May 2022 13:43:26 +0200 (CEST)
X-Loopia-Auth: user
X-Loopia-User: daniel@yesql.se
X-Loopia-Originating-IP: 89.255.232.193
Received: from smtpclient.apple (customer-89-255-232-193.stosn.net
 [89.255.232.193])
	(Authenticated sender: daniel@yesql.se)
	by s899.loopia.se (Postfix) with ESMTPSA id A92472C8BA6D;
	Tue,  3 May 2022 13:43:26 +0200 (CEST)
From: Daniel Gustafsson <daniel@yesql.se>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.80.82.1.1\))
Subject: Re: BETWEEN operator not indexed
Date: Tue, 3 May 2022 13:43:26 +0200
References: <165155543337.686.679884113562719745@wrigleys.postgresql.org>
To: j@wezel.name,
 pgsql-docs@lists.postgresql.org
In-Reply-To: <165155543337.686.679884113562719745@wrigleys.postgresql.org>
Message-Id: <B2F0325A-0771-4CBF-9719-788CDE990726@yesql.se>
X-Mailer: Apple Mail (2.3696.80.82.1.1)
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/B2F0325A-0771-4CBF-9719-788CDE990726%40yesql.se>
Precedence: bulk

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