JSON question
От | Dave Ekhaus |
---|---|
Тема | JSON question |
Дата | |
Msg-id | 1362aceb-cc4a-45f4-b57d-0b56b878ca83@Canary обсуждение исходный текст |
Список | pgsql-general |

Hi All
I'm experimenting with PostgreSQL's JSON features and have a question.
Say we have the following JSON (which will be stored in a table named 'resources' - in its 'schema' column ...
{
"name": {
"type": "string",
"label": "Name",
"accessor": "name",
"is_association": false
},
"books": {
"type": "array",
"label": "Books",
"accessor": "books",
"is_association": true
},
"email": {
"type": "string",
"label": "Email",
"accessor": "email",
"is_association": false
},
"date_of_birth": {
"type": "date",
"label": "Birthday",
"accessor": "date_of_birth",
"is_association": false
}
}
[NOTE: the JSON above is the 'schema' attribute of one record in the 'resources' table. There will be many rows in the 'resources' table]
How can I query the 'resources' table to return the rows in which there's at least one JSON object whose 'type' equals 'array' ?
Thanks
Dave
В списке pgsql-general по дате отправления: