Re: JSON: @@-operator
Tom Lane <[email protected]> Tue, 29 Oct 2019 19:35:55 -0400
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
PG Doc comments form <[email protected]> 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