Re: ORDER BY elements in ARRAY

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

       ) as person_array

FROM onp_crm_relation comp
ORDER BY person_array
;