| From: | Przemysław Sztoch <przemyslaw(at)sztoch(dot)pl> |
|---|---|
| To: | "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru> |
| Cc: | Andrey Borodin <amborodin86(at)gmail(dot)com>, Jelte Fennema <postgres(at)jeltef(dot)nl>, Nick Babadzhanian <pgnickb(at)gmail(dot)com>, Mat Arye <mat(at)timescaledb(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Daniel Gustafsson <daniel(at)yesql(dot)se>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, "Kyzer Davis (kydavis)" <kydavis(at)cisco(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "brad(at)peabody(dot)io" <brad(at)peabody(dot)io>, "wolakk(at)gmail(dot)com" <wolakk(at)gmail(dot)com>, sergeyprokhorenko(at)yahoo(dot)com(dot)au |
| Subject: | Re: Re: UUID v7 |
| Date: | 2024-01-02 23:37:28 |
| Message-ID: | d9ac9cdc-8f2e-3794-f3b2-04f354e3b311@sztoch.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dear Andrey,
1. Is it possible to add a function that returns the version of the
generated uuid?
It will be very useful.
I don't know if it's possible, but I think there are bits in the UUID
that inform about the version.
2. If there is any doubt about adding the function to the main sources
(standard development in progress), in my opinion you can definitely add
this function to the uuid-ossp extension.
3. Wouldn't it be worth including UUID version 6 as well?
4. Sometimes you will need to generate a uuid for historical time. There
should be an additional function gen_uuid_v7(timestamp).
Nevertheless, the need for uuid v6/7/8 is very high and I'm glad it's
coming to PostgreSQL. It should be a PG17 version.
--
Przemysław Sztoch | Mobile +48 509 99 00 66
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2024-01-02 23:37:41 | Re: Things I don't like about \du's "Attributes" column |
| Previous Message | Jelte Fennema-Nio | 2024-01-02 23:20:56 | Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs |