Yes, thank you. :)
-- Original Message --
From: "Sterpu Victor"
To: "Geoff Winkless"
Sent: 11/26/2015 2:51:48 PM
Subject: Re[2]: [GENERAL] ARRAY_AGG and ORDER
Yes, thank you. :)
-- Original Message --
From: "Geoff Winkless"
To: "Ster
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
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
