Re: ARRAY_AGG and ORDER

[Geoff Winkless <pgsqladmin@xxxxxxxx>]

On 26 November 2015 at 12:43, Sterpu Victor <victor@xxxxxxxx> wrote:

Hello

 

I need to order an array using another column in table ad_query_join_select.

I need something like this but this is not a valid SQL:

SELECT array_to_string(array_agg(aqjs.id ORDER BY aqjs.to_left), ',') AS str, aq.name

FROM ad_query aq

JOIN ad_query_join_select aqjs ON (aqjs.id_ad_query = aq.id)

GROUP BY aq.id, aq.name;

 

Is there some equivalent syntax in Postgres?

 

​As per the manual?

​http://www.postgresql.org/docs/current/static/sql-expressions.html#SYNTAX-AGGREGATES

​SELECT string_agg(a, ',' ORDER BY a) FROM table;