Postgres Pro
Downloads
Home   >   mailing lists

Re: remaining sql/json patches - Mailing list pgsql-hackers

From Himanshu Upadhyaya
Subject Re: remaining sql/json patches
Date
Msg-id CAPF61jD9sSbZ4u8_JtW9rcSX1ksGEr6Vc1qpUQcA5OaW==UNVw@mail.gmail.com
Whole thread Raw
In response to Re: remaining sql/json patches  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-hackers
Tree view


On Tue, Mar 12, 2024 at 5:37 PM Amit Langote <amitlangote09@gmail.com> wrote:


SELECT JSON_EXISTS(jsonb '{"customer_name": "test", "salary":1000,
"department_id":1}', '$ ? (@.department_id == $dept_id && @.salary ==
$sal)' PASSING 1000 AS sal, 1 as dept_id);
 json_exists
-------------
 t
(1 row)

Does that make sense?

Yes, got it. Thanks for the clarification. 

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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: perl: unsafe empty pattern behavior
Next
From: Amit Kapila
Date:
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation