which is better- storing data as array or json?

Поиск
Список
Период
Сортировка
От zach cruise
Тема which is better- storing data as array or json?
Дата
Msg-id CAL8icXy-NBz36L6d3bSoajDNMn98+7qeHszX-WgDPiCJzPHerg@mail.gmail.com
обсуждение исходный текст
Ответы Re: which is better- storing data as array or json?  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-general
for indexing, accessing, filtering and searching?

as simple array-
first name     | last name | nicknames
tom | jerry | {cat}, {mouse}

as multi-dimensional array-
first name     | last name | nicknames
tom | jerry | {cat, kat}, {mouse, mice}

as simple json-
first name     | last name | nicknames
tom | jerry | {"public": "cat", "private": "mouse"}

as multi-nested json-
first name     | last name | nicknames
tom | jerry     | {"public": {"first": "cat", "second": "kat"},
"private": {"first": "mouse", "second": "mice"}}


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Issue dumping schema using readonly user
Следующее
От: David G Johnston
Дата:
Сообщение: Re: which is better- storing data as array or json?