Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pjLqA-0001Fa-Ra for pgsql-general@arkaria.postgresql.org; Mon, 03 Apr 2023 15:11:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pjLq8-0000Am-6R for pgsql-general@arkaria.postgresql.org; Mon, 03 Apr 2023 15:11:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pjLq7-0000Ad-SD for pgsql-general@lists.postgresql.org; Mon, 03 Apr 2023 15:11:23 +0000 Received: from mout-u-107.mailbox.org ([2001:67c:2050:101:465::107]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pjLq5-000eQ5-I3 for pgsql-general@lists.postgresql.org; Mon, 03 Apr 2023 15:11:23 +0000 Received: from smtp102.mailbox.org (unknown [10.196.197.102]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4PqvVZ62F7z9sS0; Mon, 3 Apr 2023 17:11:18 +0200 (CEST) Date: Mon, 3 Apr 2023 17:11:17 +0200 (CEST) From: Erik Wienhold To: Adrian Klaver , pgsql-general list Message-ID: <550248534.555107.1680534677029@office.mailbox.org> In-Reply-To: <48ed779b-c405-ca4f-c2d1-5ecc0312d9a3@aklaver.com> References: <202761461.525027.1680441711777@office.mailbox.org> <48ed779b-c405-ca4f-c2d1-5ecc0312d9a3@aklaver.com> Subject: =?UTF-8?Q?Re:_=E2=80=8Bjsonb_@@_jsonpath_operator_doc:_=E2=80=8BOnly_the?= =?UTF-8?Q?_first_item_of_the_result_is_taken_into_account?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Priority: 3 Importance: Normal List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 02/04/2023 17:40 CEST Adrian Klaver wrote: > > That is a long way from: > > jsonb @@ jsonpath =E2=86=92 boolean > > Returns the result of a JSON path predicate check for the specified JSON > value. Only the first item of the result is taken into account. If the > result is not Boolean, then NULL is returned. What do you mean? I responded to the OP's question. It's not a suggestion to update the docs. Obviously it's quite a mouthful and needs to be boiled down for the docs. Any suggestions? -- Erik