Re: JSON: @@-operator

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: JSON: @@-operator
Дата
Msg-id 13000.1572392155@sss.pgh.pa.us
обсуждение исходный текст
Ответ на JSON: @@-operator  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
PG Doc comments form <noreply@postgresql.org> writes:
> The following documentation comment has been logged on the website:
> Page: https://www.postgresql.org/docs/12/functions-json.html
> Description:

> '{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2' does not work; 
> '{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2'::jsonpath works as expected

They both work for me:

regression=# select '{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2';
 ?column? 
----------
 t
(1 row)

regression=# select '{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2'::jsonpath;
 ?column? 
----------
 t
(1 row)


The most likely explanation is that you have some non-built-in
"jsonb @@ something" operator in your installation.  But you
did not say what "does not work" means, so I'm just guessing.

            regards, tom lane



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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: JSON: @@-operator
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: PostgreSQL 12 release notes missing breaking change in libpq