On Sunday, April 12, 2026, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 19454
Logged by: CN Liou
Email address: ma.sao@msa.hinet.net
PostgreSQL version: 18.3
Operating system: Linux Debian Bookworm
Description:
v_payload := v_payload || tj->'delta'; -- The problematic line
--v_payload := (SELECT v_payload || (tj->'delta')); --This avoids
the issue.
I’m not following. The problematic line above is indeed annoying but it’s not a bug. Operator precedence is behaving as documented. The second line (wrapping tj->’delta’ with parentheses) is simply the necessary way to write many expressions involving the “->”-like json[b] operators.
David J.
