Re: [GENERAL] CURRENT_TIMESTAMP

Roland Roberts wrote:
> >>>>> "Ross" == Ross J Reedstrom <reedstrm@rice.edu> writes:
>
>     Ross> Oh, interesting datapoint. Let me get this clear - on
>     Ross> oracle, the equivalent of:
>
> Well, I've never gone off to lunch in the middle, but in Oracle 7, I
> had transactions which definitely took as much as a few minutes to
> complete where the timestamp on every row committed was the same.

Can you run a test:

    BEGIN;
    SELECT CURRENT_TIMESTAMP;
    wait 5 seconds
    SELECT CURRENT_TIMESTAMP;

Are the two times the same?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073