Filter Nested JSON in PostgreSQL DB
{ "List1": [ { "f1": "b6ff", "f2": "day", "f3": "HO", "List2": [{"f1": 1.5,"f2": "RATE"}] }] } This is nested JSON in which there's a list 'List2' inside another list 'List1'. how to filter f1 = 1.5 in List2? I have…