Re: UUID v7

From: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>
To: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Cc: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, pgsql-hackers mailing list <pgsql-hackers(at)postgresql(dot)org>, Nikolay Samokhvalov <nik(at)postgres(dot)ai>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Przemysław Sztoch <przemyslaw(at)sztoch(dot)pl>, Sergey Prokhorenko <sergeyprokhorenko(at)yahoo(dot)com(dot)au>, 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>, "brad(at)peabody(dot)io" <brad(at)peabody(dot)io>, Kirk Wolak <wolakk(at)gmail(dot)com>
Subject: Re: UUID v7
Date: 2024-01-24 21:15:43
Message-ID: CAGECzQQ7QxjtuBahtZ+eJUXjkNkhi4dLWyrHP9fjDdi-BivBYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 24 Jan 2024 at 21:47, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> wrote:
>
> I understand your point, but
> '2000-01-01' :: timestamp and '1900-01-01' :: timestamp are both valid timestamps.
>
> So looks strange if user can do
> select uuidv7(TIMESTAMP '2000-01-01')
> but cannot do
> select uuidv7(TIMESTAMP '1900-01-01')

I think that would be okay honestly. I don't think there's any
reasonable value for the uuid when a timestamp is given outside of the
date range that the uuid7 "algorithm" supports.

So +1 for erroring when you provide a timestamp outside of that range
(either too far in the past or too far in the future).

In response to

  • Re: UUID v7 at 2024-01-24 20:47:07 from Marcos Pegoraro

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2024-01-24 21:16:02 Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [ NOT Fixed ]
Previous Message Marcos Pegoraro 2024-01-24 20:47:07 Re: UUID v7