Re: ORDER BY elements in ARRAY

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

> 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.
>

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’m 80% sure it’s doable, 60% in plpgsql…

David J.