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;
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 |