Y
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
michelpp
274 days ago
That still exposes the timestamp, and the shift just drops precision, so I'm not sure what you're going for here.
link
sergeyprokhoren
273 days ago
If you shift the timestamp forward by 5 thousand years, it can hardly be called just a decrease in precision.
link