Re: [GENERAL] timestamp weirdness

> >The timestamp provided as a result of evaluating 'now' is the time of
> >the start of the transaction, not the instantaneous wall clock time (if
> >you want the latter there is a function to provide it).
> We are now thinking that what is happening is that the first write
> may have a long open transaction.
> What is the function you mention to provide instantaneous time?

lockhart=# select timestamp 'now', cast(timeofday() as timestamp);
?column? | ?column?
------------------------+---------------------------
2002-02-01 17:01:19-08 | 2002-02-01 17:01:31.21-08

hth

- Thomas