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
-
Add min() and max() aggregate support for uuid.
- 2e606d75c0bf master landed