Horton

Re: ORDER BY elements in ARRAY

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Andreas Joseph Krogh <andreas@visena.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Date: 2024-08-27T12:39:34Z
Lists: pgsql-sql 
On Tuesday, August 27, 2024, Andreas Joseph Krogh <andreas@visena.com>
wrote:

> Hi, I have this query:
>
>
>
> SELECT
>     comp.entity_id as company_id, comp.companyname AS company_name
>      , ARRAY(
>         SELECT
>             (pers.entity_id
>                 , pers.firstname
>                 , pers.lastname
>                 )::PersonTypeTest
>         FROM onp_crm_person AS pers
>         WHERE pers.relation_id = comp.entity_id
>
>
> Add order by here

>
>
>        ) as person_array
>
> FROM onp_crm_relation comp
> ORDER BY person_array
> ;
>
>
David J.