Horton

Re: ORDER BY elements in ARRAY

Andreas Joseph Krogh <andreas@visena.com>

View thread View on postgr.es
From: Andreas Joseph Krogh <andreas@visena.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Date: 2024-08-27T14:59:41Z
Lists: pgsql-sql 

På tirsdag 27. august 2024 kl. 14:39:34, skrev David G. Johnston <
david.g.johnston@gmail.com <mailto: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.






--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com>
 <https://www.visena.com>