[GENERAL] ARRAY_AGG and ORDER

[Sterpu Victor]

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?

Thank you.