MIME-Version: 1.0
References: <CAASxf_MW4RBUYuS3ybbJYH9U7LQ5cjT699naiG+xKX8g=7Ut2g@mail.gmail.com>
 <202403111534.xii7yxswadef@alvherre.pgsql> <CAASxf_PqyUZTo-h0C7qyGhEZQyuC6KUjqvWA4NeAYM+XT5NWnA@mail.gmail.com>
In-Reply-To: <CAASxf_PqyUZTo-h0C7qyGhEZQyuC6KUjqvWA4NeAYM+XT5NWnA@mail.gmail.com>
From: Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>
Date: Tue, 12 Mar 2024 15:11:58 +0530
Message-ID: <CAPF61jAwzR9OKAZJzmzMXNfok-+qxSD3-HnRAL43rX8-RQrPDQ@mail.gmail.com>
Subject: Re: remaining sql/json patches
To: Alvaro Herrera <alvherre@alvh.no-ip.org>, Amit Langote <amitlangote09@gmail.com>
Cc: jian he <jian.universality@gmail.com>, Andres Freund <andres@anarazel.de>, 
	Andrew Dunstan <andrew@dunslane.net>, Erik Rijkers <er@xs4all.nl>, 
	PostgreSQL-development <pgsql-hackers@postgresql.org>, Tomas Vondra <tomas.vondra@enterprisedb.com>
Content-Type: multipart/alternative; boundary="000000000000645f750613737aca"
Archived-At: <https://www.postgresql.org/message-id/CAPF61jAwzR9OKAZJzmzMXNfok-%2BqxSD3-HnRAL43rX8-RQrPDQ%40mail.gmail.com>
Precedence: bulk

--000000000000645f750613737aca
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

wanted to share the below case:

=E2=80=98postgres[146443]=3D#=E2=80=99SELECT JSON_EXISTS(jsonb '{"customer_=
name": "test",
"salary":1000, "department_id":1}', '$.* ? (@=3D=3D $dept_id && @ =3D=3D $s=
al)'
PASSING 1000 AS sal, 1 as dept_id);
 json_exists
-------------
 f
(1 row)

isn't it supposed to return "true" as json in input is matching with both
the condition dept_id and salary?

--=20
Regards,
Himanshu Upadhyaya
EnterpriseDB: http://www.enterprisedb.com

--000000000000645f750613737aca
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>wanted to share the belo=
w case:</div><div><br></div><div>=E2=80=98postgres[146443]=3D#=E2=80=99SELE=
CT JSON_EXISTS(jsonb &#39;{&quot;customer_name&quot;: &quot;test&quot;, &qu=
ot;salary&quot;:1000, &quot;department_id&quot;:1}&#39;, &#39;$.* ? (@=3D=
=3D $dept_id &amp;&amp; @ =3D=3D $sal)&#39; PASSING 1000 AS sal, 1 as dept_=
id);<br>=C2=A0json_exists <br>-------------<br>=C2=A0f<br>(1 row)<br></div>=
<div><br></div><div>isn&#39;t it supposed to=C2=A0return=C2=A0&quot;true&qu=
ot; as json in input is matching with both the condition=C2=A0dept_id and s=
alary?</div><div><br></div><span class=3D"gmail_signature_prefix">-- </span=
><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Regards,<b=
r>
<span>Himanshu Upadhyaya</span><br>
EnterpriseDB: <a href=3D"http://www.enterprisedb.com" rel=3D"noreferrer" ta=
rget=3D"_blank">http://www.enterprisedb.com</a></div></div></div>

--000000000000645f750613737aca--