MIME-Version: 1.0
In-Reply-To: 
 <VisenaEmail.22.4c3384825217cb30.1919450fe29@origo-test01.app.internal.visena.net>
References: 
 <VisenaEmail.11.efc8bf0cbc6c75fa.1919390a6d7@origo-test01.app.internal.visena.net>
 <CAKFQuwZtFH9ZdrTvRMrE=Xq-HU0-xsmbfzmcyeSG7O5svtHW0Q@mail.gmail.com>
 <VisenaEmail.22.4c3384825217cb30.1919450fe29@origo-test01.app.internal.visena.net>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 27 Aug 2024 09:03:37 -0700
Message-ID: 
 <CAKFQuwZRaJ4AHNQZgs6pNru_WGm5MOjH+mHa3dWELNS=N_4j6w@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="0000000000006985090620ac62b6"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZRaJ4AHNQZgs6pNru_WGm5MOjH%2BmHa3dWELNS%3DN_4j6w%40mail.gmail.com>
Precedence: bulk

--0000000000006985090620ac62b6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tuesday, August 27, 2024, Andreas Joseph Krogh <andreas@visena.com>
wrote:

> P=C3=A5 tirsdag 27. august 2024 kl. 14:39:34, skrev David G. Johnston <
> david.g.johnston@gmail.com>:
>
> [=E2=80=A6]
> 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.
>

Ah.  Then either just put those two values into the first two field
positions of your custom type and live with an easy, but also
self-contained, hack, or figure out what incantations of create operator
and/or create operator family are need to install custom behavior for the
b-tree < and > operators.  I=E2=80=99m 80% sure it=E2=80=99s doable, 60% in=
 plpgsql=E2=80=A6

David J.

--0000000000006985090620ac62b6
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"><div>P=C3=A5 tirsdag 27. august 2024 kl. 14:39:34, skrev David G.=
 Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com" target=3D"_blan=
k">david.g.johnston@gmail.com</a>&gt;:</div><blockquote style=3D"border-lef=
t:1px solid rgb(204,204,204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex"><p>=
[=E2=80=A6]</p><div>Add order by here=C2=A0</div><blockquote class=3D"gmail=
_quote" style=3D"border-left:1px solid #ccc;margin:0 0 0 .8ex;padding-left:=
1ex"><pre><code>       ) as person_array

FROM onp_crm_relation comp
ORDER BY person_array
;</code></pre></blockquote><div>=C2=A0</div><div>David J.</div></blockquote=
><p>=C2=A0</p><p>This doesn&#39;t really do it. I&#39;m looking for somethi=
ng analogous to Java&#39;s <code>Comparator</code>-interface so the custom =
datatype knows how to sort itself.</p></blockquote><div><br></div><div>Ah.=
=C2=A0 Then either just put those two values into the first two field posit=
ions of your custom type and live with an easy, but also self-contained, ha=
ck, or figure out what incantations of create operator and/or create operat=
or family are need to install custom behavior for the b-tree &lt; and &gt; =
operators.=C2=A0 I=E2=80=99m 80% sure it=E2=80=99s doable, 60% in plpgsql=
=E2=80=A6</div><div><br></div><div>David J.</div><div><br></div>

--0000000000006985090620ac62b6--