[GENERAL] ARRAY_AGG and ORDER

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

Re: [GENERAL] ARRAY_AGG and ORDER

On 26 November 2015 at 12:43, Sterpu Victor 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

Re: [GENERAL] ARRAY_AGG and ORDER

Yes, thank you. :) -- Original Message -- From: "Sterpu Victor" <vic...@caido.ro> To: "Geoff Winkless" <pgsqlad...@geoff.dj> Sent: 11/26/2015 2:51:48 PM Subject: Re[2]: [GENERAL] ARRAY_AGG and ORDER Yes, thank you. :) -- Original Message --