Hi Michael, > On 02. Jul, 2020, at 14:55, Michael Lewis <mle...@entrata.com> wrote: > > Is now() computed at the time the view is defined and not at refresh? If this > were a function, I would be more suspicious of that but a plain view, surely > not. I hope.
now() returns the time at the beginning of the transaction: see: https://www.postgresql.org/docs/current/functions-datetime.html If you want the time whenever you call the function, use clock_timestamp() instead. There's also a good article at: https://www.cybertec-postgresql.com/en/postgresql-now-vs-nowtimestamp-vs-clock_timestamp/ Hope this helps. Cheers, Paul
