How to find a specific value in an array of arrays in Postgresql?

Question

PostgreSQL

You need to find all sku whose value is 735215.
An example of json is in the config column:

"stockLevels":[
{"sku":"156320","stock":0,"deliveryTimescale":{"min":5,"max":5}},
{"sku":"156322","stock":0,"deliveryTimescale":{"min":1,"max":1}},
{"sku":"156323","stock":0,"deliveryTimescale":{"min":1,"max":1}},
{"sku":"156350","stock":0,"deliveryTimescale":{"min":5,"max":5}},
{"sku":"156351","stock":0,"deliveryTimescale":{"min":5,"max":5}},
]

Answer 1

select * from your_table, 
jsonb_to_recordset((select your_table.config)->'stockLevels') 
as t (sku int, stock int, deliveryTimescale jsonb) 
where sku = 735215;

There are json functions for all occasions:
https://postgrespro.ru/docs/postgresql/11/function...