Thread: Re: ORDER BY elements in ARRAY

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
;

På tirsdag 27. august 2024 kl. 14:39:34, skrev David G. Johnston <david.g.johnston@gmail.com>:

[…]

Add order by here 

       ) as person_array

FROM onp_crm_relation comp
ORDER BY person_array
;

 

David J.

 

This doesn't really do it. I'm looking for something analogous to Java's Comparator-interface so the custom datatype knows how to sort itself.