On 26 November 2015 at 12:43, Sterpu Victor <vic...@caido.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;
