Re: ARRAY_AGG and ORDER

On 26 November 2015 at 12:43, Sterpu Victor <victor(at)caido(dot)ro> 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;