min/max aggregation for jsonb

From: Daneel Yaitskov <dyaitskov(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: min/max aggregation for jsonb
Date: 2023-03-03 04:24:50
Message-ID: CACNT4y7PWAXEmQpW9sOeoQk7QqwuRngwBPX0A148z0V4GUAmsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

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.
Is there a concern about implementing support for jsonb in min/max?

jsonb is a byte array.
json faces same limitations.

--

Best regards,
Daniil Iaitskov

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Keisuke Kuroda 2023-03-03 04:41:23 Re: Date-time extraneous fields with reserved keywords
Previous Message houzj.fnst@fujitsu.com 2023-03-03 03:40:31 RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher