Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later evaluation once one evaluation returns NULL - Mailing list pgsql-bugs

From Srinath Reddy Sadipiralla
Subject Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later evaluation once one evaluation returns NULL
Date
Msg-id CAFC+b6p8Oo3_pLXPa=DVXx1XDQJ09b2W3U3WKPtkQYyh0z0z-A@mail.gmail.com
Whole thread
In response to Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later evaluation once one evaluation returns NULL  (Srinath Reddy Sadipiralla <srinath2133@gmail.com>)
Responses Re: BUG #19695: JSON_VALUE ... RETURNING jsonb returns NULL for later evaluation once one evaluation returns NULL
List pgsql-bugs


On Fri, Sep 18, 2026 at 8:33 PM Srinath Reddy Sadipiralla <srinath2133@gmail.com> wrote:

If this approach makes sense, I can write up a formal patch along with the appropriate regression test.

Here's the patch with tests.

--
Thanks :)
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com/
Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #19693: JSON_VALUE/JSON_QUERY PASSING a toasted text value reads the toast pointer instead of the text
Next
From: shihao zhong
Date:
Subject: Re: bug: Gather rescan keeps the first scan's tuple bound in workers