public inbox for [email protected]  
help / color / mirror / Atom feed
BETWEEN operator not indexed
3+ messages / 3 participants
[nested] [flat]

* BETWEEN operator not indexed
@ 2022-05-03 05:23 PG Doc comments form <[email protected]>
  2022-05-03 11:43 ` Re: BETWEEN operator not indexed Daniel Gustafsson <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: PG Doc comments form @ 2022-05-03 05:23 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

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.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BETWEEN operator not indexed
  2022-05-03 05:23 BETWEEN operator not indexed PG Doc comments form <[email protected]>
@ 2022-05-03 11:43 ` Daniel Gustafsson <[email protected]>
  2022-05-03 12:02   ` Re: BETWEEN operator not indexed Alvaro Herrera <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Daniel Gustafsson @ 2022-05-03 11:43 UTC (permalink / raw)
  To: [email protected]; [email protected]

> On 3 May 2022, at 07:23, PG Doc comments form <[email protected]> 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/






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: BETWEEN operator not indexed
  2022-05-03 05:23 BETWEEN operator not indexed PG Doc comments form <[email protected]>
  2022-05-03 11:43 ` Re: BETWEEN operator not indexed Daniel Gustafsson <[email protected]>
@ 2022-05-03 12:02   ` Alvaro Herrera <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Alvaro Herrera @ 2022-05-03 12:02 UTC (permalink / raw)
  To: Daniel Gustafsson <[email protected]>; +Cc: [email protected]; [email protected]

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/






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2022-05-03 12:02 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-05-03 05:23 BETWEEN operator not indexed PG Doc comments form <[email protected]>
2022-05-03 11:43 ` Daniel Gustafsson <[email protected]>
2022-05-03 12:02   ` Alvaro Herrera <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox