By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| a | exists (select 1 from json_table(t.b, '$[*]' columns (foo text path '$.foo')) t3 where t3.foo = t.a) |
|---|---|
| a | 1 |
| a | exists (select 1 from json_table(t.b, '$[*]' columns (foo text path '$.foo')) t3 where t3.foo = t.a) |
|---|---|
| a | 1 |