Horton

Re: UUID v7

Marcos Pegoraro <marcos@f10.com.br>

View thread View on postgr.es
From: Marcos Pegoraro <marcos@f10.com.br>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: "Andrey M. Borodin" <x4mmm@yandex-team.ru>, Peter Eisentraut <peter@eisentraut.org>, Jelte Fennema-Nio <postgres@jeltef.nl>, Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>, Przemysław Sztoch <przemyslaw@sztoch.pl>, Michael Paquier <michael@paquier.xyz>, Aleksander Alekseev <aleksander@timescale.com>, pgsql-hackers mailing list <pgsql-hackers@postgresql.org>, "David G. Johnston" <david.g.johnston@gmail.com>, Mat Arye <mat@timescaledb.com>, Matthias van de Meent <boekewurm+postgres@gmail.com>, Nikolay Samokhvalov <samokhvalov@gmail.com>, Junwang Zhao <zhjwpku@gmail.com>, Stepan Neretin <sncfmgg@gmail.com>
Date: 2024-11-29T19:46:54Z
Lists: pgsql-hackers 
Em sex., 29 de nov. de 2024 às 15:49, Masahiko Sawada <sawada.mshk@gmail.com>
escreveu:

>  <function>uuidv7</function> () <returnvalue>uuid</returnvalue>
>

Wouldn't it be better to change this to
 <function>uuidv7</function> ([interval]) <returnvalue>uuid</returnvalue
and explain what that param is ?

regards
Marcos

Commits

  1. Fix timestamp overflow in UUIDv7 implementation.

  2. Add UUID version 7 generation function.

  3. Add some UUID support functions