Re: ARRAY_AGG and ORDER

From: "Sterpu Victor" <victor(at)caido(dot)ro>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ARRAY_AGG and ORDER
Date: 2015-11-26 12:52:26
Message-ID: em0337b323-952a-4e65-be90-42d590d5b4dd@victor-pc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes, thank you. :)

------ Original Message ------
From: "Sterpu Victor" <victor(at)caido(dot)ro>
To: "Geoff Winkless" <pgsqladmin(at)geoff(dot)dj>
Sent: 11/26/2015 2:51:48 PM
Subject: Re[2]: [GENERAL] ARRAY_AGG and ORDER

>Yes, thank you. :)
>
>
>------ Original Message ------
>From: "Geoff Winkless" <pgsqladmin(at)geoff(dot)dj>
>To: "Sterpu Victor" <victor(at)caido(dot)ro>
>Cc: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
>Sent: 11/26/2015 2:46:33 PM
>Subject: Re: [GENERAL] ARRAY_AGG and ORDER
>
>>On 26 November 2015 at 12:43, Sterpu Victor <victor(at)caido(dot)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.idORDER 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;

Browse pgsql-general by date

  From Date Subject
Next Message krichy 2015-11-26 14:35:49 long transactions / backend memory usage
Previous Message Geoff Winkless 2015-11-26 12:46:33 Re: ARRAY_AGG and ORDER