Re: Add MIN/MAX aggregate support for uuid

From: "Tristan Partin" <tristan(at)partin(dot)io>
To: "Masahiko Sawada" <sawada(dot)mshk(at)gmail(dot)com>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add MIN/MAX aggregate support for uuid
Date: 2026-06-24 19:13:36
Message-ID: DJHIOZ0SRKX3.3BHWQQ9JL7YWO@partin.io
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed Jun 24, 2026 at 6:13 PM UTC, Masahiko Sawada wrote:
> On Wed, Jun 24, 2026 at 10:50 AM Tristan Partin <tristan(at)partin(dot)io> wrote:
>> Attached is a v2.
>
> The patch mostly looks good to me. One minor comment is:
>
> +{ oid => '6519', proname => 'uuid_larger', proleakproof => 't',
> + prorettype => 'uuid', proargtypes => 'uuid uuid', prosrc => 'uuid_larger' },
> +{ oid => '6520', proname => 'uuid_smaller', proleakproof => 't',
> + prorettype => 'uuid', proargtypes => 'uuid uuid', prosrc => 'uuid_smaller' },
>
> I think we should add the 'decr' to both functions.

Any opinions on what the descriptions should be? Here are the equivalent
functions for OID:

{ oid => '1965', descr => 'larger of two',
proname => 'oidlarger', prorettype => 'oid', proargtypes => 'oid oid',
prosrc => 'oidlarger' },
{ oid => '1966', descr => 'smaller of two',
proname => 'oidsmaller', prorettype => 'oid', proargtypes => 'oid oid',
prosrc => 'oidsmaller' },

--
Tristan Partin
PostgreSQL Contributors Team
AWS (https://aws.amazon.com)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-06-24 19:31:33 Re: Proposal: Conflict log history table for Logical Replication
Previous Message Melanie Plageman 2026-06-24 18:59:22 Re: autovacuum launcher crash: assert in pgstat_count_io_op (IOOP_EXTEND on pg_database's VM)