Postgres - Increment value in json

Question

Hello I have column of type JSON where I store for example '{ "foo": 0 }' now I would like to write trigger which will be increment value on specific action. I have problem because I don't know how increment or set 0 value if updated value not exist. I tried to write function similar to code from here: https://stackoverflow.com/a/44563662/10999632 but It is not possible because:

ERROR:  function jsonb_set(json, unknown, jsonb) does not exist
LINE 2: SET payload = jsonb_set(payload, '{bar}', (COALESCE(payload-...
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

user330315 · Accepted Answer · 2020-05-13 11:35:02Z

1

Apparently your column payload is defined as json, not jsonb.

You need to cast the column to jsonb in order to be able to use jsonb_set()

SET payload = jsonb_set(payload::jsonb, '{bar}', ...)

answered May 13, 2020 at 11:35

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres - Increment value in json

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related