Re: ORDER BY elements in ARRAY
| От | David G. Johnston |
|---|---|
| Тема | Re: ORDER BY elements in ARRAY |
| Дата | |
| Msg-id | CAKFQuwZRaJ4AHNQZgs6pNru_WGm5MOjH+mHa3dWELNS=N_4j6w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ORDER BY elements in ARRAY ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Список | pgsql-sql |
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.
В списке pgsql-sql по дате отправления: