top | item 45279215

(no title)

sergeyprokhoren | 5 months 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

discuss

order

michelpp|5 months ago

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

sergeyprokhoren|5 months ago

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