On Tuesday, August 27, 2024, Andreas Joseph Krogh <
andreas@visena.com> wrote:
[…]
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.
