Hi All,
I run Postgres13 (PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit)
I have a jsonb field type (fieldname is test), like below JSON array format, how to update is_read properties in extras node to true where the users_pid=1 and is_read = false?
Code:
[
{