Re: BETWEEN operator not indexed

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: BETWEEN operator not indexed
Дата
Msg-id B2F0325A-0771-4CBF-9719-788CDE990726@yesql.se
обсуждение исходный текст
Ответ на BETWEEN operator not indexed  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: BETWEEN operator not indexed  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-docs
> 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/




В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: BETWEEN operator not indexed
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BETWEEN operator not indexed