[Pgpool-general] Time differences

[Adonias Malosso]

Bruno,

If you have less than 1 second difference between the hosts you could try to
truncate the current timestamp result to seconds or minutes, depending on
your application needs, for example:

UPDATE public.transporte SET ativo = false, ts = CURRENT_TIMESTAMP
WHERE age(date_trunc('minute', current_timestamp)::timestamp,ts) > '2 hours'


Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20081008/c920d59f/attachment.html