Support UUIDv6 in uuid_extract_timestamp()

From: "Tristan Partin" <tristan(at)partin(dot)io>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Support UUIDv6 in uuid_extract_timestamp()
Date: 2026-06-24 20:09:59
Message-ID: DJHJW50YWKIT.XIOT4NOZRQ03@partin.io
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

UUIDv6 is the same as UUIDv1 with some fields reordered. We already
supported UUIDv1, so let's add support for UUIDv6. Previously, calls to
uuid_extract_timestamp() would return NULL for UUIDv6 values.

Patch 2 only adds comments. I think the bit manipulation is worthy of
comments, but others may disagree.

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

Attachment Content-Type Size
v1-0001-Support-UUIDv6-in-uuid_extract_timestamp.patch text/x-patch 3.8 KB
v1-0002-Add-comments-to-uuid_extract_timestamp.patch text/x-patch 2.9 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2026-06-24 20:16:49 Re: The PostgreSQL C Dialect
Previous Message Christophe Pettus 2026-06-24 20:09:03 Re: The PostgreSQL C Dialect