Horton

Fix constant when extracting timestamp from UUIDv7.

Masahiko Sawada <msawada@postgresql.org>

View on postgr.es
Commit: 37265ca01f0f361a3aff23e27dfc81b66057a039
Author: Masahiko Sawada <msawada@postgresql.org>
Date: 2025-08-15T18:58:53Z
Releases: 19 (unreleased) 
Fix constant when extracting timestamp from UUIDv7.

When extracting a timestamp from a UUIDv7, a conversion from
milliseconds to microseconds was using the incorrect constant
NS_PER_US instead of US_PER_MS. Although both constants have the same
value, this fix improves code clarity by using the semantically
correct constant.

Backpatch to v18, where UUIDv7 was introduced.

Author: Erik Nordström <erik@tigerdata.com>
Reviewed-by: Andrey Borodin <x4mmm@yandex-team.ru>
Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com>
Discussion: https://postgr.es/m/CACAa4V+i07eaP6h4MHNydZeX47kkLPwAg0sqe67R=M5tLdxNuQ@mail.gmail.com
Backpatch-through: 18

Files

PathChange+/−
src/backend/utils/adt/uuid.c modified +1 −1

Discussion