Remix.run Logo
sergeyprokhoren 5 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

michelpp 5 days ago | parent [-]

That still exposes the timestamp, and the shift just drops precision, so I'm not sure what you're going for here.

sergeyprokhoren 4 days ago | parent [-]

If you shift the timestamp forward by 5 thousand years, it can hardly be called just a decrease in precision.