Add jsonb property of type boolean

Question

I'm trying to add a property to an existing jsonb column (column "data").

I want have my jsonb document to log like this

{
  // ... existing properties
  "Filed": false // new property
}

I tried

UPDATE "doc" SET "data" = jsonb_set("data"::jsonb, 'Filed', false, true)

I get this error:

[42883] ERROR: function jsonb_set(jsonb, unknown, boolean, boolean) does not exist 
Hint: No function matches the given name and argument types. 
You might need to add explicit type casts. Position: 46

Laurenz Albe · Accepted Answer · 2022-10-07 12:59:01Z

1

It should be

jsonb_set("data"::jsonb, '{Filed}', 'false', TRUE)

The second parameter is an array denoting the path to the appropriate key, and 'false' is the string representation of a JSON boolean.

edited Oct 7, 2022 at 12:59

user330315

answered Oct 7, 2022 at 12:25

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Comments

Stefanov.sm · Accepted Answer · 2022-10-07 12:13:01Z

0

Better use the || operator.

UPDATE "doc" SET "data" = "data" || '{"Filed": false}';

This one is equivalent but more suitable for parameterization:

UPDATE "doc" SET "data" = "data" || jsonb_build_object('Filed', false);

answered Oct 7, 2022 at 12:13

Stefanov.sm

13.2k2 gold badges24 silver badges24 bronze badges

Collectives™ on Stack Overflow

Add jsonb property of type boolean

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related