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 по дате отправления: