which is better- storing data as array or json?

[zach cruise <zachc1980@xxxxxxxxx>]

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"}}


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general