How to make SQL selection in an array?

Question

SQL

there is table1 with column elements.
this column stores values ​​as an array:
{
"arr_val1": {
"0": {
"value": "z333z"
}
},
"arr_val2": {
"0": {
"value": "z593z"
}
}
}
how to get a selection of rows where ['arr_val2'][0]['value'] = z593z ???

Answer 1

Well, since it is not written whose SQL it is, then suppose postgresql>=9.3 www.postgresql.org/docs/9.3/static/functions-json.html