Re: Add MIN/MAX aggregate support for uuid

Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
To: Tristan Partin <tristan@partin.io>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2026-06-24T19:47:13Z
Lists: pgsql-hackers
Hi,

On Wed, Jun 24, 2026 at 12:13 PM Tristan Partin <tristan@partin.io> wrote:
>
> 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' },

What you have in the v2 patch looks fine to me. "minimum/maximum value
of all UUID input values" gives it a bit of an "aggregate flavor" as
well - as in, when used in select min(uuid_col) from foo, it returns
the minimum value of all UUID input values.

-- 
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com



Commits

  1. Add min() and max() aggregate support for uuid.