Software architect and consultant Oskar Dudycz shares a tale of negative experiences with PostgreSQL's timestamp functions inside transactions, that led to a fiendishly difficult to diagnose bug.
TL;DR? There is subtle, yet important difference between now() and clock_timestamp(), specially if you're measuring time lapse inside a transaction.
"How soon is now in PostgreSQL?"
https://www.architecture-weekly.com/p/how-soon-is-now-in-postgresql
#postgresql #timestamps #programming #transactions #databases


