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 по дате отправления:

Предыдущее
От: BeginnerC
Дата:
Сообщение: Where is the best place to read for the paper around database?
Следующее
От: "J. Roeleveld"
Дата:
Сообщение: Re: Select .... where id not in (....) returns 0 incorrectly