Modify Nested Arrays in PostgreSQL JSON/B Columns
Postgres does not provide modification operations for nested JSON arrays out-of-the-box. By combining some JSON utility functions with array functions you can achieve dynamic update statements to do adding/removing by value. Example Let's create a...