'How to filter jsonb array elements
I have a table with a jsonb column which contains an array of objects:
create table my_table(
id int primary key,
phones jsonb);
The objects consist of phone numbers and statuses.
insert into my_table values
(1,
'[
{
"phone": "929908338",
"status": "active"
},
{
"phone": "927007729",
"status": "inactive"
},
{
"phone": "927220419",
"status": "inactive"
},
{
"phone": "928200028",
"status": "inactive"
},
{
"phone": "927183322",
"status": "inactive"
},
{
"phone": "928424554",
"status": "active"
},
{
"phone": "927779383",
"status": "inactive"
}
]');
I want to get all phones with active status in a single row. Expected output:
["929908338","928424554"]
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
