Re: min/max aggregation for jsonb - Mailing list pgsql-hackers

From David Rowley
Subject Re: min/max aggregation for jsonb
Date
Msg-id CAApHDvr=fbq6B1Ohda670V-Bg+5iyeu6etzj2F0pTk0i=m4MRQ@mail.gmail.com
Whole thread Raw
In response to min/max aggregation for jsonb  (Daneel Yaitskov <dyaitskov@gmail.com>)
Responses Re: min/max aggregation for jsonb  (Daneel Yaitskov <dyaitskov@gmail.com>)
Re: min/max aggregation for jsonb  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
On Fri, 3 Mar 2023 at 23:17, Daneel Yaitskov <dyaitskov@gmail.com> wrote:
> I wanted to use min/max aggregation functions for jsonb type and noticed
> there is no functions for this type, meanwhile string/array types are supported.

It's not really clear to me how you'd want these to sort. If you just
want to sort by what the output that you see from the type's output
function then you might get what you need by casting to text.

> Is there a concern about implementing support for jsonb in min/max?

I imagine a lack of any meaningful way of comparing two jsonb values
to find out which is greater than the other is of some concern.

David



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Next
From: Bharath Rupireddy
Date:
Subject: Re: Deduplicate logicalrep_read_tuple()