PostgreSQL: update json issue

Question

Table has a json-column named "stats" with the following value: {"countValue":0}

I'm trying to update this value by:

 UPDATE my_table
 SET stats = jsonb_set(stats, '{countValue}', 1);

But receive the following error:

 No function matches the given name and argument types. You might need to add explicit type casts.

I tried to fix the problem, by applying explicit type cast for countValue (countValue::text), but with the same result.

What am I doing wrong?

D-Shih · Accepted Answer · 2022-03-27 15:59:51Z

1

You might need to use jsonb type on '1' instead of integer from jsonb_set function signature

jsonb_set(target jsonb, path text[], new_value jsonb [, create_missing boolean])

UPDATE my_table
SET stats = jsonb_set(stats, '{countValue}', '1');

answered Mar 27, 2022 at 15:59

D-Shih

46.5k6 gold badges37 silver badges56 bronze badges

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

1 Answer 1