JSON is an acronym for JavaScript Object Notation.
To create an object in JavaScript you can do:
var myobj = new Object(); myobj.prop = 1;
Using JSON you'd do:
var myobj = {prop:1};
To create a new array you can do:
var a = new Array(); a[a.length] = 1; a[a.length] = 2;
or using JSON:
var a = [1, 2];
arrayjavascriptjsonliteralobject
It is possible to order by an array element as follows:
SELECT * FROM (SELECT ARRAY[1, 2, 3] AS foo) sub ORDER BY foo[1];
arrayobscurepostgresqlsqlsyntax