Re: Unable to make use of "deep" JSONB index

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Unable to make use of "deep" JSONB index
Дата
Msg-id CAKFQuwbdruA3kZh7Efxwd_jUX_eYXu63PqVuFnKg3ym3tY0iXg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unable to make use of "deep" JSONB index  (Shaheed Haque <shaheedhaque@gmail.com>)
Список pgsql-bugs
On Sun, Jun 12, 2022 at 4:52 PM Shaheed Haque <shaheedhaque@gmail.com> wrote:
    ...USING btree ((snapshot -> 'employee' @? '$.* ? (@.pay_graph != 0)'));
    ...WHERE        ((snapshot -> 'employee' @? '$."999" ? (@.pay_graph != 0)'))

To my inexpert eye, given the presence of the wildcard, the above look
like an exact match. What have I missed?


The system doesn't see a wildcard.  Exact match means identical characters.  The fact that you had to write "given the presence of the wildcard" is why this is not an exact match.

David J.

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

Предыдущее
От: Shaheed Haque
Дата:
Сообщение: Re: Unable to make use of "deep" JSONB index
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Unable to make use of "deep" JSONB index