By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
2 rows affected
| mydata |
|---|
| {"my_data": [{"pid": 1, "stock": 500}, {"pid": 2, "stock": 1000}]} |
| mydata | value | pid | product_name |
|---|---|---|---|
| {"my_data": [{"pid": 1, "stock": 500}, {"pid": 2, "stock": 1000}]} | {"pid": 2, "stock": 1000} | 2 | def |
| {"my_data": [{"pid": 1, "stock": 500}, {"pid": 2, "stock": 1000}]} | {"pid": 1, "stock": 500} | 1 | abc |