Re: ORDER BY elements in ARRAY

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: ORDER BY elements in ARRAY
Date: 2024-08-27 14:59:41
Message-ID: VisenaEmail.22.4c3384825217cb30.1919450fe29@origo-test01.app.internal.visena.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

På tirsdag 27. august 2024 kl. 14:39:34, skrev David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)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(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2024-08-27 15:34:55 Re: object mapping for json/jsonb columns
Previous Message David G. Johnston 2024-08-27 12:39:34 Re: ORDER BY elements in ARRAY