Re: how to add seconds to a TimestampTz

Alvaro Herrera wrote:
> Is there a better way than going to time_t and back? I am currently
> using this:
>
> db->next_worker =
> time_t_to_timestamptz(timestamptz_to_time_t(current_time) +
> autovacuum_naptime);
>
> (db->next_worker is a TimestampTz, as is current_time.
> autovacuum_naptime is integer for a number of seconds)

For the archives, I just discovered on timestamp.h this macro to help:

avdb->ad_next_worker =
TimestampTzPlusMilliseconds(now, naptime_secs * 1000);

This is a lot simpler and faster ...

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support