Hi all, I have a table called portal and it is having a column called status_id.

seq_id | segment | exp 
-------------+--------+-----------
          20 |      1 |        -1
          25 |      1 |        -1
          23 |      1 |        -1
          22 |      1 |        -1
          19 |      1 |        -1
          26 |      1 |        -2
          21 |      1 |        -1
          24 |      1 |        -1

id | seg_id |        experience        
----+--------+--------------------
 20 |      1 | {"work": 0}
 25 |      1 | {"work": 0}
 23 |      1 | {"work": 0}
 22 |      1 | {"work": 0}
 19 |      1 | {"work": 0}
 26 |      1 | {"work": 0}
 21 |      1 | {"work": 0}
 24 |      1 | {"work": 0}

UPDATE info SET experience = '{"work": (portal.exp)}' FROM portal WHERE exp IS NOT NULL AND seq_id = info.id;

But it's not working

What am I missing?

Any one?

You should update json fields with proper operations, such as jsonb_set

https://www.postgresql.org/docs/11/functions-json.html

Hi I'm a beginner to making web apps and I'm really interested in learning more about databases. I'd love to have more general knowledge & understanding of a broad range of DB topics. I've been googling lots of things, but I think a book might include interesting topics I wouldn't have thought to research. What beginner books/blogs/websites do you recommend?

This might be a helpful read @bradj4333 https://mariadb.com/kb/en/introduction-to-relational-databases/ (it seems to cover a lot of the basics in bite-size chunks).

@seancorfield thank you I'll look into that, sounds like just what i'm looking for!