Re: ORDER BY elements in ARRAY

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: ORDER BY elements in ARRAY
Date: 2024-08-27 12:39:34
Message-ID: CAKFQuwZtFH9ZdrTvRMrE=Xq-HU0-xsmbfzmcyeSG7O5svtHW0Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tuesday, August 27, 2024, Andreas Joseph Krogh <andreas(at)visena(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2024-08-27 14:59:41 Re: ORDER BY elements in ARRAY
Previous Message Jan Bernitt 2024-08-27 12:28:58 object mapping for json/jsonb columns