BETWEEN operator not indexed

Поиск
Список
Период
Сортировка
Искать

BETWEEN operator not indexed

От:
PG Doc comments form <noreply@postgresql.org>
Дата:
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.

Re: BETWEEN operator not indexed

От:
Alvaro Herrera <alvherre@alvh.no-ip.org>
Дата:
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/


Re: BETWEEN operator not indexed

От:
Daniel Gustafsson <daniel@yesql.se>
Дата:
> On 3 May 2022, at 07:23, PG Doc comments form  wrote:

> The BETWEEN operator can't be found by searching.

It is actually indexed, but it can indeed not be searched on its own.

    
     BETWEEN
    
    
     BETWEEN SYMMETRIC
    

A wild guess; perhaps between is defined in a stopwords list for searching
somewhere?

--
Daniel Gustafsson		https://vmware.com/



FAQ