parsed.org
Order By Array Subscript by cygnus on Jan 12, 2005 10:25 AM

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
RSS