valerian <valerian2(at)hotpop(dot)com> writes:
> The only thing I can think of is that pgsql cached an old date and time,
> for some reason, and used that for the first record, and then actually
> queried the system's date/time after that.
Is it possible that the entry was made from a transaction that had been
sitting open for two days? now() and related functions return
transaction start time.
regards, tom lane