Re: UUID v7
От | Junwang Zhao |
---|---|
Тема | Re: UUID v7 |
Дата | |
Msg-id | CAEG8a3JUgkY3EMp393kJ+bcye8q=VHfQDTQz7Ci-moNVjhPLZA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: UUID v7 ("Andrey M. Borodin" <x4mmm@yandex-team.ru>) |
Ответы |
Re: UUID v7
|
Список | pgsql-hackers |
Hi Andrey, On Tue, Jan 30, 2024 at 5:56 PM Andrey M. Borodin <x4mmm@yandex-team.ru> wrote: > > > > > On 30 Jan 2024, at 12:28, Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au> wrote: > > > > > > I think this phrase is outdated: "This function can optionally accept a timestamp used instead of current time. > > This allows implementation of k-way sotable identifiers.” > Fixed. > > > This phrase is wrong: "Both functions return a version 4 (random) UUID.” > This applies to functions gen_random_uuid() and uuidv4(). > > > > For this phrase the reason is unclear and the phrase is most likely incorrect: > > if large batches of UUIDs are generated at the > > + same time it's possible that some UUIDs will store a time that is slightly later > > + than their actual generation time > > I’ve rewritten this phrase, hope it’s more clear now. > > > Best regards, Andrey Borodin. +Datum +uuid_extract_var(PG_FUNCTION_ARGS) +{ + pg_uuid_t *uuid = PG_GETARG_UUID_P(0); + uint16_t result; + result = uuid->data[8] >> 6; + + PG_RETURN_UINT16(result); +} \ No newline at end of file It's always good to add a newline at the end of a source file, though this might be nitpicky. -- Regards Junwang Zhao
В списке pgsql-hackers по дате отправления: