[wiredfool]

Dates from times are a minefield.

I just had a long-standing bug come to the fore because I shifted a view to a materialized view, and embedded deep down in it was a date cast from a time stamp with tome zone.

When running as a view, everything was done in the user's time zone (because tits set per connection). When it’s a materialized view, it's he refresher's time zone.

This led to some inconsistencies, as the server is properly but inconveniently in UTC.