Option for GEN_UUID to generate v7 UUID

[r1gm]

UUID v7 more index-able than UUID v4(Current used in FirebirdSQL, CMIIW), please bring support for UUID v7 in FirebirdSql.

[mrotteveel]

As far as I'm aware, the relevant RFC hasn't been published yet, so as of now, there is no official v7 UUID, and implementation at this time would be premature.

[sergeyprokhorenko]

However, no changes will be made to the text of the RFC. Therefore, no one waits for official approval:
Rust
PostgreSQL
JavaScript
Google
etc.

[michaelpq]

PostgreSQL

FWIW, I doubt that any PostgreSQL committer will be OK to push a patch to add support for UUIDv7 without an approved RFC. There is too much risk in finishing with a non-compliant behavior.

[piervalli]

Hi All
In Postgresql after many revisitions uuid7 is approved for next version.

https://commitfest.postgresql.org/47/4388/

[basid-irk]

RFC 9562 Universally Unique IDentifiers (UUIDs)

RFC: 9562
Obsoletes: 4122
Category: Standards Track
Published: May 2024
ISSN: 2070-1721

[reevespaul]

I know gen_uuid() generates UUID v4 but surely the new syntax should also support gen_uuid(4).

And is there any plan to backport this feature to v4 and v5?

[mrotteveel]

@reevespaul The syntax accepts GEN_UUID(), which uses 4 and GEN_UUID(4) and GEN_UUID(7).