MIME-Version: 1.0
In-Reply-To: 
 <VisenaEmail.11.efc8bf0cbc6c75fa.1919390a6d7@origo-test01.app.internal.visena.net>
References: 
 <VisenaEmail.11.efc8bf0cbc6c75fa.1919390a6d7@origo-test01.app.internal.visena.net>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 27 Aug 2024 05:39:34 -0700
Message-ID: 
 <CAKFQuwZtFH9ZdrTvRMrE=Xq-HU0-xsmbfzmcyeSG7O5svtHW0Q@mail.gmail.com>
Subject: Re: ORDER BY elements in ARRAY
To: Andreas Joseph Krogh <andreas@visena.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b467690620a98826"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZtFH9ZdrTvRMrE%3DXq-HU0-xsmbfzmcyeSG7O5svtHW0Q%40mail.gmail.com>
Precedence: bulk

--000000000000b467690620a98826
Content-Type: text/plain; charset="UTF-8"

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.

--000000000000b467690620a98826
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tuesday, August 27, 2024, Andreas Joseph Krogh &lt;<a href=3D"mailto:and=
reas@visena.com">andreas@visena.com</a>&gt; wrote:<br><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><p>Hi, I have this query:</p><p>=C2=A0</p><pre><code>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 =3D comp.entity_id</code></pre><pre><code><b=
r></code></pre><pre></pre></blockquote><div>Add order by here=C2=A0<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:=
1px #ccc solid;padding-left:1ex"><pre></pre><pre><code><br></code></pre><pr=
e><code>
       ) as person_array

FROM onp_crm_relation comp
ORDER BY person_array
;</code></pre><pre></pre></blockquote><div>=C2=A0</div><div>David J.</div><=
div>=C2=A0</div>

--000000000000b467690620a98826--