From: Tom Lane <tgl@sss.pgh.pa.us>
To: kowarschick@gmail.com
cc: pgsql-docs@lists.postgresql.org
Subject: Re: JSON: @@-operator
In-reply-to: <157236654810.1042.9358599433792740462@wrigleys.postgresql.org>
References: <157236654810.1042.9358599433792740462@wrigleys.postgresql.org>
Comments: In-reply-to PG Doc comments form <noreply@postgresql.org>
	message dated "Tue, 29 Oct 2019 16:29:08 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <12999.1572392155.1@sss.pgh.pa.us>
Date: Tue, 29 Oct 2019 19:35:55 -0400
Message-ID: <13000.1572392155@sss.pgh.pa.us>
Precedence: bulk

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