Hacker News new | ask | show | jobs
by sergeyprokhoren 274 days ago
Bad idea. In PostgreSQL 18 the optional parameter shift will shift the computed timestamp by the given interval

https://www.postgresql.org/docs/18/functions-uuid.html

1 comments

That still exposes the timestamp, and the shift just drops precision, so I'm not sure what you're going for here.
If you shift the timestamp forward by 5 thousand years, it can hardly be called just a decrease in precision.