Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

So I have a json field that contains an object of title

```json
{
  "native":"镇魂街",
  "romaji":"Zhen Hun Jie",
  "english":null,
  "userPreferred":"Zhen Hun Jie"
}
```
now I want to add a new property to it, it should be

```json
{
  "native":"镇魂街",
  "romaji":"Zhen Hun Jie",
  "english":null,
  "userPreferred":"Zhen Hun Jie",
  "vietnamese": "Trấn Hồn Nhai 2"
}
```

This is what I've tried so far, it worked with one row, but when I try to run it on all rows, it return this error

`invalid input syntax for type json`

```ps
UPDATE kaguya_anime
SET title = title::JSONB || concat('{"vietnamese":"', "vietnameseTitle", '"}')::JSONB
WHERE "vietnameseTitle" IS NOT NULL
```

Can you elaborate on what you means it works on one row, but not all?  What is the difference in you SQL between the two?

I solved it, thanks for your helping 🙂

```ps
UPDATE kaguya_anime
SET title = title::JSONB || jsonb_set(title::JSONB, '{vietnamese}', to_jsonb("vietnameseTitle"))
WHERE "vietnameseTitle" IS NOT NULL
```