Re: [GENERAL] ARRAY_AGG and ORDER

2015-11-26 Thread Sterpu Victor
pu Victor" Cc: "PostgreSQL General" Sent: 11/26/2015 2:46:33 PM Subject: 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

Re: [GENERAL] ARRAY_AGG and ORDER

2015-11-26 Thread Geoff Winkless
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 str, aq.name > FRO