Hi Michael,
> On 02. Jul, 2020, at 14:55, Michael Lewis <mlewis@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
suspiciousof 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