Feature: add ability to extract timestamps

[t3hmrman]

Context

Some UUIDs have time components embedded in them that can be extracted.

While not ever UUID generation mechanism can return a native type like uuid, it should be clear which type the function is returning.

Proposal

Given a text value that has been generated by pg_idkit with a function like idkit_<mechanism>_generate (or a similar function), there should be a function idkit_<mechanism>_extract_timestamptz_from_<type>

For example:

• User generates a new UUID as text with idkit_uuidv6_generate
• User can use idkit_uuidv6_extract_timestamptz_from_text on the value to get a timestamptz

Alternatives

N/A

Additional Links

N/A

[t3hmrman]

Implemented for cuid (despite cuid being deprecated in favor of cuid2) in https://github.com/VADOSWARE/pg_idkit/commit/e10879b0cade592d8ad89fac709e0c07f049a978

[t3hmrman]

UUID v7 handled in https://github.com/VADOSWARE/pg_idkit/pull/38

UUID v6 handled in https://github.com/VADOSWARE/pg_idkit/pull/37

[t3hmrman]

PushID is not implemented, but as it depends on some upstream code (a branch makes with some WIP changes), I'm going to add a stretch goal to add support for it.